Viewing 15 posts - 6,436 through 6,450 (of 15,381 total)
Jeffrey Williams 3188 (10/22/2013)
Sean Lange (10/22/2013)
polkadot (10/22/2013)
October 22, 2013 at 1:30 pm
mario17 (10/22/2013)
I have some custom mapping to apply which has ~500 cases, does it worth to code it with CASE or probably I can do something more nicer, like use...
October 22, 2013 at 1:22 pm
polkadot (10/22/2013)
1. allows nulls
2. originally came from another database
3. occasionally contains the word NULL in it
4. is empty half the time
what are all the...
October 22, 2013 at 1:16 pm
Oh yeah...just yesterday somebody posted this link for something similar.
You might take a look. I think it might be a starting point. The cursor could be avoided. I am pretty...
October 22, 2013 at 12:54 pm
dcesharkman (10/22/2013)
Yes they do. This requirement is for a Content deployment service of sorts
Gotcha 100% loud and clear now. As you eluded SSIS would be a far better choice for...
October 22, 2013 at 12:51 pm
dcesharkman (10/22/2013)
INSERT [dbo].[Address] ([ID], [Address1], [Address2], [City], [State], [ZipCode], [AddressTypeID], [IsPrimary], [CountryId], [Address_no_old]) VALUES (4, N'52123 Go Street', N'', N'Othertown', N'CA',...
October 22, 2013 at 12:11 pm
dcesharkman (10/22/2013)
October 22, 2013 at 11:01 am
dcesharkman (10/22/2013)
I need to create a adaptive insert statements transferring data in one table to a table on a different...
October 22, 2013 at 9:50 am
I don't think you need a loop here at all. However I am a little unclear on exactly what you are trying to do. Are you trying to generate a...
October 22, 2013 at 8:58 am
mario17 (10/21/2013)
Tx a lot, it works,is it possible to operate only on few columns from sp output ?
I don't need all and don't want to do extra temp table.
Best
M
Nope....
October 22, 2013 at 7:40 am
SrcName (10/22/2013)
declare @input varchar(50)='100,200,300,400,500'select '1', q2.value from
( SELECT cast('<x>'+replace(@input,',','</x><x>')+'</x>' as xml) as txml ) q1 CROSS APPLY
( SELECT x.value('.','varchar(100)') as value FROM txml.nodes('x') as f(x) )q2
You too should have...
October 22, 2013 at 7:28 am
newdba_sql (10/21/2013)
I have noticed that some time one or two of...
October 21, 2013 at 3:30 pm
Jack Corbett (10/21/2013)
SQLRNNR (10/21/2013)
1. Thanks to Koen. Manning the support lines (SSC) while many of us were incognito. You had the best...
October 21, 2013 at 3:09 pm
Koen Verbeeck (10/21/2013)
Sean Lange (10/21/2013)
ericwenger1 (10/21/2013)
Can I get some recommendations on some Database Reverse Engineering Tools?Thanks in advance!
What are you trying to reverse engineer? Are you trying to get...
October 21, 2013 at 2:04 pm
It is close. Had to remove TEXTIMAGE ON for the Parts table. That wasn't to big a deal.
The WOParts table just doesn't work well. You defined the primary key as...
October 21, 2013 at 1:57 pm
Viewing 15 posts - 6,436 through 6,450 (of 15,381 total)