gchappell (1/8/2013)

---

my company wishes to add 200 million new products in the next 10 days. Does sql server 2012 have any limits as to how much data can be added...

Post the code of the stored procedure. Without it, the best folks can do is guess.

Minnu (1/8/2013)

---

Sorry,,,

Small change in my requeirement...

Table_Name : Table1

Col_1Col_2

----------------------

100Prod

101Sales

102Mark

103Purc

if exists (select 1 from Table1 where Col_1=100) then

i want to get the corresponding column value of 100, that is "Prod" as...

MM_SQLQuestion (1/8/2013)

---

This is returning all the records in Table1 not only the records of LinkField IN (1,2,3,4)

So I had to change it to

select NameField,COUNT(table2.LinkField) FROM

Table1

LEFT JOIN Table2 ON Table1.LinkField...

;WITH CTE AS

(

SELECT forumId,ParentId,HitNumber,

Seq = CAST(','+CAST(forumId AS VARCHAR(2)) AS VARCHAR(20))

FROM #tab1

WHERE ParentId IS NULL

UNION ALL

SELECT DD2.forumId, DD2.ParentId, DD2.HitNumber,

Seq = CAST(CTE.Seq + ',' + CAST(DD2.forumId AS VARCHAR(2)) AS VARCHAR(20))

FROM...

ScottPletcher (1/7/2013)

---

If all the columns are from a single table, you definitely should created a computed column that has the computation: that way, the definition is in only one place....

Stefan Krzywicki (1/7/2013)

---

Brandie Tarvin (1/7/2013)

---

jasona.work (1/7/2013)

---

It's not that bad...

I've been...

It looks ok to me, Terry. Try this:

SELECT

ID,

Result =

case when FB_chk = -1 Then ' FB_chk=True' else '' end

+ case when TW_chk = -1 Then ' TW_chk=True' else...

It's easier to read, when rewritten like this:

SELECT

p.StockCode,

MIN(CASE WHEN orders.[Week] = 1 THEN orders.Supplier END) AS [1],

.

.

MIN(CASE WHEN orders.[Week] = 53 THEN orders.Supplier END) AS [53]

FROM dbo.Products p

INNER...

Meh, I just knew someone would pick this up 😛

Happy New Year to all of you special people on this thread who keep us mere mortals amused during our all-too-brief lunchtimes. May 2013 bring you excitement, enlightenment and all...

Yes it did Steve and you've been a baaad boy or...

Gianluca Sartori (12/21/2012)

---

ChrisM@Work (12/21/2012)

---

I thought that big scary yellow thing in the sky was the zombie...

I thought that big scary yellow thing in the sky was the zombie apocalypse until I...

Anybody out there?