Viewing 15 posts - 2,611 through 2,625 (of 2,894 total)
I've been advising the same all the way long...
But, for some reason, he loves a cursor 😀
July 1, 2010 at 12:51 pm
lionwelp (7/1/2010)
Eugene Elutin (7/1/2010)
...
July 1, 2010 at 10:13 am
Just remember, to use FileStream in SQL2008 your system must use Windows Authentication when connecting to SQLServer, but I beleive it already does :-D.
July 1, 2010 at 9:42 am
Do you want the most recent status to display? Which column defines that it is a most recent status? vvers_dat or creatie__dat or something else?
July 1, 2010 at 9:14 am
I don't understand your question. Are you asking how to use IF ... ELSE in SQL or what?
Just in case: http://msdn.microsoft.com/en-us/library/ms182587.aspx
July 1, 2010 at 9:07 am
It is a bad practice to use cursor or any kind of loop to do what you are trying to do in T-SQL.
It will be better if you will create...
July 1, 2010 at 8:57 am
You can use SUBSTRING function, it works on varbinary datatype.
July 1, 2010 at 8:16 am
You will find comparison table in this article:
http://msdn.microsoft.com/en-us/library/dd425070(SQL.100).aspx
July 1, 2010 at 7:59 am
You can use the following in your WHERE clause:
WHERE (SGYR = @SGYR OR @SGYR IS NULL)
AND (REGION = @REGION OR @REGION IS NULL)
AND (SEASON = @SEASON OR @SEASON IS NULL)
AND...
July 1, 2010 at 7:52 am
jay83091 (7/1/2010)
e.g. for the current month of July 2010
20104 - previous QTD
20105 - previous QTD
20106 - previous QTD
20107 - current QTD
20108 - current QTD
20109 - current QTD
thanks for your help...
July 1, 2010 at 4:02 am
chris-736523 (6/30/2010)
I'll declare the input parameter as
@ParameterName VARCHAR(4000)
Then, whatever is calling the procedure needs to pass a comma delimited string of values. Example "1,2,3,4,5,6".
In...
June 30, 2010 at 3:34 pm
It could be due to the code is auto-generated...
And obviuosly it was not done very well 😎
June 30, 2010 at 3:14 pm
PaulB-TheOneAndOnly (6/30/2010)
...:blink: mmhhh... having problems to picture an scenario where performance improves by adding I/O.
I don't think performance is the only concern when designing a database. Would you denormalize...
June 30, 2010 at 3:08 pm
Brandie Tarvin (6/30/2010)
I don't think I can use FranchiseID or StoreID in my newly generated TaxID. And since I'll be using this technique for other PII (address information, etc), I'd...
June 30, 2010 at 10:26 am
Dave, please test the script you post before posting it.
It doesn't work against DDL submitted in your previous post (it doesn't work at all as there are no quotes around...
June 30, 2010 at 10:19 am
Viewing 15 posts - 2,611 through 2,625 (of 2,894 total)