I've been advising the same all the way long...

But, for some reason, he loves a cursor 😀

lionwelp (7/1/2010)

---

Eugene Elutin (7/1/2010)

---

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?

...

Just remember, to use FileStream in SQL2008 your system must use Windows Authentication when connecting to SQLServer, but I beleive it already does :-D.

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?

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

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...

You can use SUBSTRING function, it works on varbinary datatype.

You will find comparison table in this article:

http://msdn.microsoft.com/en-us/library/dd425070(SQL.100).aspx

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...

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...

chris-736523 (6/30/2010)

---

I do this frequently.

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...

It could be due to the code is auto-generated...

And obviuosly it was not done very well 😎

I don't think performance is the only concern when designing a database. Would you denormalize...

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...

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...