Viewing 15 posts - 9,781 through 9,795 (of 13,874 total)
john_agger (6/26/2013)
create table #test( testtext varchar(30)
, MyRand varchar(5) DEFAULT(REPLACE( STR(...
June 26, 2013 at 10:02 pm
dob111283 (6/25/2013)
June 25, 2013 at 10:49 pm
sql2k8 (6/25/2013)
June 25, 2013 at 9:59 am
Vertigo44 (6/25/2013)
Can someone show me how to select all patients that hasve seen more than one provider over the past month please? Would this be a cte?
You're not new here,...
June 25, 2013 at 8:08 am
foxxo (6/25/2013)
Leave your existing settings as they are, the destination will be changed by the expression on execution.
You'll need a variable...
June 25, 2013 at 1:11 am
tiffanyb (6/24/2013)
I currently have text files sent monthly that need to be imported into SQL server. I'm new to SSIS and have fumbled my way through importing each one using...
June 24, 2013 at 11:47 pm
dob111283 (6/19/2013)
June 24, 2013 at 7:39 am
Can you just put the PKs of the main table to be deleted in the temp table, then index it, then join on that.
Also, you need to surround your deletes...
June 24, 2013 at 1:55 am
If you search your input file for the text 2314K, it should point you in the right direction.
It looks like whichever column that data is in is mapped to an...
June 23, 2013 at 10:43 pm
sagar.gadwe (6/21/2013)
How to convert binary file to text file in ssis package and i want to load it into the table.
As far as I know, binary files would make no...
June 21, 2013 at 7:54 am
Well, if I were you I would suggest it, so that when the pain of maintaining your IDENTITY solution becomes too much to bear, you can always be the smart...
June 21, 2013 at 7:40 am
No doubt it's too late to change this, but have you thought about using NewId rather than identity as your (nonclustered) PK in the various tables?
As far as I...
June 21, 2013 at 6:44 am
Attached excel file? This sounds like homework or someone at the office asking for a very odd request.
The attached Excel file appears to have become detached.
June 21, 2013 at 12:27 am
You need to find out which row it is - possibly by exporting the imported table to Excel and then doing some sort of VLOOKUP comparison - and then work...
June 21, 2013 at 12:22 am
William Plourde (6/20/2013)
Phil Parkin (6/20/2013)
June 20, 2013 at 7:22 am
Viewing 15 posts - 9,781 through 9,795 (of 13,874 total)