neeraj-344433 (4/27/2015)

---

Hi there,

I have been assigned to optimize a query which was taking 16 hours to run. So worked around and brought it down to 32 minutes. (for data testing,...

DSNOSPAM (4/24/2015)

---

I guess you should let me know what you mean by code.

Unless it's really quick and dirty, there's no time to set up code. I'm just being thrown...

forrest77 (4/24/2015)

---

SELECT Empid,

STUFF (

...

Phil Parkin (4/24/2015)

---

This won't help you right now, but maybe in future. You should put some sort of unique constraint on your table which would result in an error if...

forrest77 (4/24/2015)

---

Hi, I would like to create a table valued function that fetch through the table below using a cursor and return the records that are unique. Open to...

henryalugo (4/24/2015)

---

Great!! I didn't know if you got to see my verbiage in my first message (towards the bottom), but in the event you haven't I'll add it here:

So I...

henryalugo (4/24/2015)

---

My apologies! my first time using the site with visual example: here is a virtual table you can use:

CREATE TABLE #temptable (ReportingMonth Varchar(6), Fee_Code Varchar(20), Fee_Transaction_Amount Decimal(12,2),...

BOR15K (4/24/2015)

---

Sean Lange (4/24/2015)

---

We can help but first you have to help us. We need some information here to offer any assistance. Please take a few minutes and read the...

We can help but first you have to help us. We need some information here to offer any assistance. Please take a few minutes and read the first link in...

We can certainly help but we need a little bit more information. Please take a few minutes and read the first article in my signature for best practices when posting...

cunningham (4/24/2015)

---

it's not important that identity can't be null as the OP isn't going to do that. my phrasing of the question was 'can you add a nullable auto increment'...

cunningham (4/24/2015)

---

that's why i added

you can then do a data compare using a 3rd party tool (sql datacompare by redgate is one) to verify the data is the same....

Aaron N. Cutshall (4/24/2015)

---

Sean Lange (4/24/2015)

---

All of the syntax available for sql server??? Are you kidding??? The document would be too big to read. That is why technet has it...

cunningham (4/24/2015)

---

Can you add a nullable auto increment column to the table? this will have little impact, as the autoincrement will start when the next insert occurs. then you...

Aaron N. Cutshall (4/24/2015)

---

Does anyone know if a single document or book (in an eBook format) that contains all of the SQL Server syntax available? What I'm looking for...