surma.sql (7/5/2012)

---

hello

i have trouble to declare a variable. i try to declare string variable but it gives me null value

declare @vcDisplaySchoolName varchar

set @vcDisplaySchoolName = 'CITY CONNECTIONS- EAST'

select vcDisplaySchoolName from tblSchools

where...

joe.eager (7/5/2012)

---

Lynn Pettis (7/5/2012)

---

And I found it. Try this in place of my original code above.

DECLARE @StateFipsCSV varchar(500) = '01,03'

SELECT

*

FROM

[dbo].[ProductInventory] prdinv

WHERE

exists (SELECT instr.Item FROM dbo.DelimitedSplit8K(@StateFipsCSV,',') instr INNER JOIN

...

And I found it. Try this in place of my original code above.

DECLARE @StateFipsCSV varchar(500) = '01,03'

SELECT

*

FROM

[dbo].[ProductInventory] prdinv

WHERE

exists (SELECT instr.Item FROM dbo.DelimitedSplit8K(@StateFipsCSV,',') instr INNER JOIN

...

Note, you may get duplicate rows of data if there are multiple matches, so I'm sure that there may be other ways to accomplish this. I am looking at...

I had to modify your code slightly, I don't have your schema in my Sandbox database.

First, the delimited split routine I use.

/****** Object: UserDefinedFunction [dbo].[DelimitedSplit8K] Script...

Show us the expected result set from the query based on the sample data. Hate to say it, but I can figure things out much better when I can...

joe.eager (7/5/2012)

---

Lynn Pettis (7/5/2012)

---

joe.eager (7/5/2012)

---

Lynn Pettis (7/5/2012)

---

Can you explain a little more what you are trying to return? In fact, it may help if you put together the DDL...

joe.eager (7/5/2012)

---

Lynn Pettis (7/5/2012)

---

Can you explain a little more what you are trying to return? In fact, it may help if you put together the DDL (CREATE TABLE statement),...

Can you explain a little more what you are trying to return? In fact, it may help if you put together the DDL (CREATE TABLE statement), some sample data,...

Or, if you can afford to lose point in time recovery during the index maintenance period, have the the process change the database from FULL recovery model to BULK_LOGGED recovery...

Koen Verbeeck (7/4/2012)

---

Here you go:

http://www.sqlservercentral.com/Forums/Topic1323601-1292-1.aspx#bm1324127

I...

Not sure what you are talking about. I took my code from above and changed DATE to...

ScottPletcher (7/3/2012)

---

Lynn Pettis (7/3/2012)

---

ScottPletcher (7/3/2012)

---

It's a pretty sure bet you have...

Mr. Celko actually posting a helpful reply!

I'll read it and provide some feedback.