Viewing 15 posts - 181 through 195 (of 3,232 total)
Management Studios does not have the ability to sync databases for you. You can do a stare-and-compare by visually examining 2 different DBs, but it will not do the...
January 6, 2011 at 2:03 pm
Add a conditional split in your data flow that looks at the column you want to check. Then route the rows that match the condition to an OLE DB...
January 5, 2011 at 1:22 pm
IF OBJECT_ID('TempDB..#test','u') IS NOT NULL
DROP TABLE #test
SELECT TOP 1
[name],
...
January 5, 2011 at 12:30 pm
SELECT OBJECT_NAME(object_id)
FROMsys.columns
WHEREname = 'column name here'
December 20, 2010 at 3:28 pm
Declare @strStartTime varchar(50)
select @strStartTime = '12/10/2010'
SELECT CAST(@strStartTime as datetime)
December 17, 2010 at 11:03 am
Tom.Thomson (12/15/2010)
Granddaughter.Not quite random word. My first one was born very early this morning.
Congrats!!
December 15, 2010 at 2:52 pm
CirquedeSQLeil (12/15/2010)
crookj (12/15/2010)
John Rowan (12/15/2010)
CirquedeSQLeil (12/15/2010)
Announcement (to be made)Drum roll pease.....
Can only hold my breath for so long......
Joe
I will be posting more in my blog
Where's you blog site?
...nevermind 🙂
December 15, 2010 at 12:44 pm
CirquedeSQLeil (12/15/2010)
Announcement (to be made)
Drum roll pease.....
December 15, 2010 at 10:20 am
CirquedeSQLeil (12/14/2010)
ch-ch-ch-changes
Ditto
December 14, 2010 at 1:33 pm
jscot91,
Is this a new question from a new poster or did you change user names?
If this is a new question from a new poster, please post a new thread...
December 13, 2010 at 8:28 am
An execution plan here would help a bunch. You shouldn't have to bother with the temp table to make this work.
The challenge with adding Status to the clustered index...
December 9, 2010 at 12:55 pm
Viewing 15 posts - 181 through 195 (of 3,232 total)