Viewing 15 posts - 1 through 15 (of 22 total)
Thanks you for your reply.. but
I did do that and this takes away the Date picker (small calender) next to the parameter input textbox and converts it to a drop...
January 27, 2011 at 11:33 am
Also,
if you want to avoid
SET QUOTED_IDENTIFIER OFF
you can also use this
Select *
from t
where c1 = 'ASO ''02 CHOICE 06'
here there are two single quotes before 02 which sql...
September 30, 2009 at 9:49 am
That works perfectly. just what I wanted.
Thanks a lot
September 29, 2009 at 1:38 pm
its still not formatted.
(Here is how it looks)
for
@query = 'select top 2 customerid, contactname, city from customers'
@body_format = 'html'
Result in the email:-
customerid, contactname, city --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ------------------------------------------ ---------------------------------------------------------- ----------------------------------------------------------------------------------------------------...
September 29, 2009 at 1:25 pm
the combination of Fname and phone is the primary key to the table
September 25, 2009 at 6:03 pm
Just what i was looking for...
works perfectly
thank you so much
September 25, 2009 at 11:16 am
i already have this table created. i just gave you the top few rows of it. I dont think i can update the table with %%LockRes%%
so will need...
September 25, 2009 at 10:09 am
This deletes all the columns from the table
September 25, 2009 at 7:10 am
Sounds good, that could certainly be one way to do it.
I am thinking my having a composite primary key of firstname and primary phone which would help me for looking...
September 24, 2009 at 9:04 am
Thanks for your reply, I will give you more detailed information here.
Currently my table does not exist. I was looking to create the table in the package. the import datatypes...
September 24, 2009 at 8:17 am
this is basically a personal requirement.
I have my contacts imported in csv file. now the csv file contains around 40 columns like
first name, last name, phone, fax, web, business fax,...
September 24, 2009 at 7:36 am
So what kind of data flow transformation in SSIS will help achieve the removing of ALL NULL columns before loading it into database
September 23, 2009 at 11:39 am
i cannot untick them because there are around 40 columns with 100's of rows in the csv file. so checking if a column is null or not is not appropriate.
is...
September 23, 2009 at 8:19 am
I need to solve the above problem.. but i was thinking of a workaround
is there a way i can display current page number in a textbox in the report no...
April 14, 2009 at 2:18 pm
at any given time all the 3 subreports will be printed together.
can you please explain your reply a bit more for this condition.
Thanks a lot
April 14, 2009 at 8:55 am
Viewing 15 posts - 1 through 15 (of 22 total)