Viewing 15 posts - 11,326 through 11,340 (of 15,381 total)
See if this article helps. http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D
July 18, 2012 at 8:10 am
Kingston Dhasian (7/18/2012)
Lowell (7/18/2012)
the function attached to this article is recommended by myself any my peers:+1
Definitely. The other method uses a While loop which might give performance issues.
+1 again. 😀
July 18, 2012 at 7:38 am
Vera-428803 (7/18/2012)
Hi, thanks for the replies.Yes, we considered using SSIS, but depending on the content of the excel sheet, we send a mail or not.
SSIS can send mail. http://msdn.microsoft.com/en-us/library/ms142165.aspx Seems...
July 18, 2012 at 7:35 am
Yeah it is pretty hard to tell exactly what you are doing here but it appears you have a scalar function called split to parse your strings. You should check...
July 18, 2012 at 7:32 am
You have a couple of things going on here. The first is you have some data in period_name that can't be converted to a datetime. This is what is causing...
July 17, 2012 at 8:55 pm
And using set rowcount is not a good habit to learn now. It will no longer affect insert, update or delete in the NEXT version of sql. It is better...
July 17, 2012 at 8:24 pm
Welsh Corgi (7/17/2012)
There are no Go Stement between each Merge which may be a good thing.
Will the scripts execute in parallel and...
July 17, 2012 at 3:11 pm
pistolpete (7/17/2012)
July 17, 2012 at 1:51 pm
edstewart (7/17/2012)
Agreed, it is a horrible design. My hands are tied on this one, so I'm have to go with the flow, hence the question. Thanks everyone for their help!
You...
July 17, 2012 at 1:48 pm
capn.hector (7/17/2012)
July 17, 2012 at 1:15 pm
You have been around here long enough to know that you should post ddl, sample data and desired output. Read the article at the first link in my signature. Post...
July 17, 2012 at 12:43 pm
Nice job posting ddl and sample data. I am however complete confused with what you want this query to do. Can you try explaining this again more clearly?
July 17, 2012 at 12:41 pm
capn.hector (7/17/2012)
Sean Lange (7/17/2012)
capn.hector (7/17/2012)
DECLARE @STR VARCHAR(8000)
SET @STR = 'Rang the client and agreed they would begin to pay off...
July 17, 2012 at 12:33 pm
capn.hector (7/17/2012)
DECLARE @STR VARCHAR(8000)
SET @STR = 'Rang the client and agreed they would begin to pay off £x off their...
July 17, 2012 at 11:15 am
Check out Gail's article on how to post performance problems.
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D
July 17, 2012 at 10:37 am
Viewing 15 posts - 11,326 through 11,340 (of 15,381 total)