This is not a good...

Fermented with barley and hops.

kapil_kk (4/3/2013)

---

Hi all, I have created a sp in which I want to extract last identity value after doing insertion....

But its giving me error that @new_identity parameter is not...

T.Ashish (4/2/2013)

---

Hi All,

This query is running slow due to a TABLE VALUED function in select clause. Definition of query and function is pasted below. Table...

Hi and welcome to SSC. It is nearly impossible to offer much assistance based on the details in your post. I am willing to help but I need something to...

Duplicate post. Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1438227-150-1.aspx

This should work based on the sample data.

;with Marketing as

(

select *, ROW_NUMBER() over (order by MyName) as RowNum

from #Data

where Department = 'Marketing'

)

, IT as

(

select *, ROW_NUMBER() over (order by MyName)...

FunkyDexter (4/3/2013)

---

I'm fairly sure he's trying to front load the Qty into the Aging column which is actually a capacity. I've put a better explanation...

Evil Kraig F (4/2/2013)

---

Sean Lange (4/2/2013)

---

If you are...

If you are going to go that route...

sqlfriends (4/2/2013)

---

Lowell (4/2/2013)

---

i would consider disabling and re-enabling them instead; either way it's effectively the same thing:

select

'ALTER TABLE '

+ QUOTENAME(schema_name(schema_id))

+ '.'

+ quotename(name)

+ ' NOCHECK CONSTRAINT...

If you want...

If your data is violating your FK constraints, which from the sounds of your post it is, dropping the constraints to import the data isn't going to help. You will...

kk1173 (4/2/2013)

---

If I have a query like

Select * from table1 WHERE ColVal IN (Select AllVals from table2)

Is it not better to have the following instead? It will bring in those...

Yeah...