Welsh Corgi (6/28/2012)

---

Does anything appear to be wrong with the following CASE Statement?

It always updates the First Column correctly but in most instances it does not update the 2nd and...

Bond 007

Mahesh Gupta-325917 (6/28/2012)

---

I’m trying to insert data from 1 table to another in a specific order.

Lets say in table1, I have data saying 4,2,3,1

Now I need to insert data...

faijurrahuman17 (6/28/2012)

---

HI ;

How to split the csv values in rows , this is my sample string

UNIPAR LLC , IAE Power Products , MID-AM Equipment Inc.

, Diesel Electrical Equipment,...

Satnam Singh (6/28/2012)

---

Friends,

I am having a serious performance problem with the below query:

SELECT DATEADD(mi, (SELECT BiasInMinutes FROM A WHERE ...

bala2 (6/28/2012)

---

We have a table strucure as below..

Tabe-A

A-d-int,pk,notnull

A_H--nvarchar(10),null

A_dn-navrchar

A-S-int,null

A_c-date(smalldatetime,null

Table-B,

B_d --int(PK,not null)

B_H---int,notnull,

B_Dn---nvarchar(14),notnull)

B_c_date--(smalldatetime,null)

B-si--(int,null)

B_DT--(smalldatetime,null)

when we are using the below insert into query we are got the error as "Msg 245, Level 16, State 1,...

Grass (6/27/2012)

---

Hi:

I am new to SSIS and SQL Server. I have a package that copy data from source table to destination table. In the source table I have column name...

hmm.....don't worry have a look on link in my signature for creating sample data.

However to...

dwain.c (6/27/2012)

---

But if you're wedded to CASE you can do it like this:

SELECT @CMD=

case

when @model = 'Global' then

'SELECT '+@model+' AS Model

, Scenario_ID

FROM lp_Scenario AS a'

Else

'SELECT '+@model+' AS Model

,...

leesider (6/27/2012)

---

Silly me, I am able to work around it by right-clicking and selecting "Script Stored procedure as" and then "Alter to".

Don't know why modify is doing that but the...

achen9291 (6/27/2012)

---

right here it has 3 blocks. i need it to display 10 of them. from the first data in #proxylog_count_2 then get the 2nd and third, etc.

the code above...

achen9291 (6/27/2012)

---

I'm trying to loop this set of code so that it gets the first, second, third,... tenth data in multiple blocks.

Select ClientUserName, DestHost, count(DestHost) counts from #ProxyLog_record...

achen9291 (6/27/2012)

---

Sorry I hope I can clarify better.

#ProxyLog_count_2 is ordered by counts.

there are 2 columns in proxylog_count_2, ClientUserName and counts. but i only want to display ClientUserName

so i use this....

Elasticity !!!

dwilliscp (6/27/2012)

---

In a Stored Proc, can you use a CASE statement to create your SQL ... (the below try errors out on 'Case'

ALTER procedure [dbo].[test]

@model ...