And Lowell is correct, proper formatting of your code will help you find syntax problems, like missing END's for CASE's or parens, etc.

White space is your friend, not your enemy.

Geez, Lowell, you take all the fun out making the OP tell us what the problem is... 😉

dba.nivali (11/12/2009)

---

select (case when substring(svc_ord_nbr,1,1) = 'V' and svc_ord_nbr like '%COG%' then 'VIDEO' else

case when substring(svc_ord_nbr,1,1) = 'Z' and svc_ord_nbr like '%COG%'...

ROTFLMAO !! :w00t:

Look up a couple of posts. 😉

How about something like this?

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

BEGIN TRAN

update table_num_schema set

@nextvalue = next_value = next_value + 1;

where

name...

GDI Lord (11/12/2009)

---

And the complex answer? 😉

Actually, X5 only has two values, 'A' and 'B'. Unless using only those two values is better for this specific query, although it goes...

How about showing us what you have written so far? This way we can see what you are trying to do and provide you with some constructive feedback.

Mark Harr (11/12/2009)

---

I second Ed Vassie's question on the supposed JCL limitation.

I got the answer right, only because the category was SSIS and I figured that one of those two...

Okay, learned something new this morning about SSIS and multiple flat files.

Good question!

GDI Lord (11/12/2009)

---

Hey guys

Current index definition:

CREATE NONCLUSTERED INDEX [IX_tblX_X1X2X3X4X5] ON [dbo].[tblX]

(

X1 ASC, -- VARCHAR(8)

X2 ASC, -- VARCHAR(6)

X3 ASC, -- VARCHAR(3)

X4 ASC, -- VARCHAR(6)

X5 ASC -- VARCHAR(2)

)

INCLUDE (X6, X7,...

First, in the Object Explorer window of SSMS, look for tempdb under System Databases. Right click on tempdb and select Reports, then Standard Reports, then Disk Usage. If...

andre_quitta (11/11/2009)

---

I have a table with an INT identity, Company and Type, among other columns. I need to match a row with the previous instance of that row for that...

seandeyoung-1145978 (11/11/2009)

---

Pretty good assumption based on that I was asking how I could find the information in the metadata of the instance of the server. I should have rephrased my...

Jim-720070 (11/2/2009)

---

Apologies for adding to what seems to be a resolved thread.. BUT! I was having a very, very similar issue.

My sp looked something like this:

CREATE sp_blahblah @month INTEGER (YYYYMM)...