Viewing 15 posts - 9,781 through 9,795 (of 13,880 total)
suryam (6/27/2013)
June 27, 2013 at 2:03 am
suryam (6/27/2013)
now here below are my table details
/*************/
create table #Mis
(
region varchar(50),
branch varchar(60),
trdate datetime,
reportcnt int,
pendingcnt int
)
insert into #Mis values ('Bangalore','BG40-BELGAUM','2013-05-06 00:00:00.000',0,1)
insert into #Mis...
June 27, 2013 at 1:21 am
You're not new here & should know the drill by now.
Please see the link in my signature - we need consumable DDL and INSERT statements to make it easier for...
June 27, 2013 at 12:26 am
This sounds fairly straightforward, but it's impossible to provide working code without some additional help from you.
Specifically, we need consumable DDL and sample data (in the form of INSERT statements),...
June 27, 2013 at 12:00 am
El_Mou (6/26/2013)
so this is my context : i have a rapport who work perfectly...
June 26, 2013 at 11:48 pm
Does that mean that you wish to read only those rows which have been inserted or updated in 'the last fifteen minutes' every time the job runs?
June 26, 2013 at 10:10 pm
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
Viewing 15 posts - 9,781 through 9,795 (of 13,880 total)