patrickmcginnis59 10839 (7/28/2014)

---

Sean Lange (7/28/2014)

---

patrickmcginnis59 10839 (7/28/2014)

I'm looking at the replies in this very post. Diarrhea? Yes, probably "good natured fun" as probably seen by the threadizens, but from the...

Phil Parkin (7/28/2014)

---

Here is how I would try to do it.

Do an INSERT to your identities table such that it generates all of the idents you need in one hit.

Then...

patrickmcginnis59 10839 (7/28/2014)

---

Sean Lange (7/28/2014)

---

patrickmcginnis59 10839 (7/28/2014)

---

Koen Verbeeck (7/28/2014)

---

patrickmcginnis59 10839 (7/28/2014)

---

Ed Wagner (7/28/2014)

---

SQLRNNR (7/27/2014)

---

Jeff Moden (7/26/2014)

---

That might be where the word "Overflow" comes...

bantrim (7/28/2014)

---

Koen Verbeeck (7/28/2014)

---

bantrim (7/28/2014)

---

Lynn Pettis (7/28/2014)

---

bantrim (7/28/2014)

---

I'm interested in this answer as well. I have definitely encountered a fair amount of pretentious responses and posts there (then again,...

dorisdelaney (7/28/2014)

---

I have a temporary table that can have anywhere from one to maybe 15 records each day. I am trying to insert into another table using SCOPE_IDENTITY. ...

Try this:

(DT_STR,4,1252)DATEPART("yyyy",DATEADD("Month",-1,GETDATE()))...

bantrim (7/28/2014)

---

I'm interested in this answer as well. I have definitely encountered a fair amount of pretentious responses and posts there (then again, look at this thread's topic), but...

Sindhu Ravi (7/28/2014)

---

You can do this as below (note: Check for the performance issues before implementing)

declare @date datetime

select @date=MAX(date) from #mytable where...

First, please pay attention to how I setup the test data. This is something you should do for us. I found it easier for this solution to use...

jonathan_blac15 (7/27/2014)

---

Hi all,

I'm hoping someone can help as I'm clueless 🙂

I'm looking for some TSQL script that filters the method field by A, except for the latest date which I...

Here is the code I run on our systems to look at performance. Also use it for identifying blocking as that happens more often. Couldn't air gap it...

Welsh Corgi (7/27/2014)

---

I have a Wait Type Suspended Wait Type CXPacket Request Command Insert going on for 7 hours.

It is the only active process hat is active.

I do not know...

I'm going to say it depends. When first starting to work with one, almost necessary to get a feel for the recruiter and the company. Sometimes this is...

Eirikur Eiriksson (7/26/2014)

---

...

I've seen some utterly horrid .NET (and almost anything else also) answers, the problem is exactly what you said earlier, most of the time one cannot down-vote the...

Also, it would help to know what indexes are defined on the tables.