Viewing 15 posts - 11,311 through 11,325 (of 15,376 total)
lokeshvij (7/18/2012)
Not sure why are you using all this for range --> use substring insteadCheck this link:
I am not sure how substring would help in this case but...
July 18, 2012 at 1:00 pm
dtopicdragovic (7/18/2012)
July 18, 2012 at 12:57 pm
XMLSQLNinja (7/18/2012)
First thought was that we would connect to current db and do updates directly (validating fields before update).
Good Grief! First and foremost - NEVER do that. As a...
July 18, 2012 at 12:49 pm
tacy.highland (7/18/2012)
However, I ran into issues recreating your cteTally table. I took a look at the link you provided for creating the tally table but...
July 18, 2012 at 12:39 pm
nvm misread the original question.
July 18, 2012 at 12:22 pm
SQLRNNR (7/18/2012)
Sean Lange (7/18/2012)
Danzz (7/18/2012)
Can I get T-sql statement.Actually if you read the article it is really quite simple.
Thank you.:-D
You're welcome. Not sure how I never found that one before....
July 18, 2012 at 12:16 pm
Danzz (7/18/2012)
Can I get T-sql statement.
Actually if you read the article it is really quite simple.
July 18, 2012 at 12:12 pm
tacy.highland (7/18/2012)
July 18, 2012 at 11:05 am
Charmer (7/18/2012)
I already took this cursor when anthony.green redirected me to the above link...I slightly modified this cusror and i got the result what i was looking for.
Thank you Sean....
You...
July 18, 2012 at 10:40 am
Without ddl, sample data and desired output nobody can do much to help. At best we can take a shot in the dark and see if it might work. If...
July 18, 2012 at 10:31 am
This request is WAY beyond the scope of an online forum. You are asking somebody to design your entire application and database. If you are truly stuck at the starting...
July 18, 2012 at 8:34 am
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
Viewing 15 posts - 11,311 through 11,325 (of 15,376 total)