djj (11/12/2015)

---

Grant Fritchey (11/12/2015)

---

Still, could be fun. Build out a nested CTE inside a function, use the same table aliases over and over, don't format the code. It'll be impossible...

Luis Cazares (11/11/2015)

---

Sean Lange (11/11/2015)

---

rxm119528 (11/11/2015)

---

Apologies for the missing loop. Thanks for the different approaches. I just wanted to learn the other ways we can append those sequence of numbers...

rxm119528 (11/11/2015)

---

Apologies for the missing loop. Thanks for the different approaches. I just wanted to learn the other ways we can append those sequence of numbers with out using the...

It is extremely unclear what you are trying to do but does something like get you pointed in the right direction? This is far simpler (and faster) than nested while...

Have you looked at using the Error connector? It is not totally clear what you want to do but error handling in SSIS is pretty robust. What have you tried?

Duplicate post. Here is the original. http://www.sqlservercentral.com/Forums/Topic1735535-148-1.aspx

rxm119528 (11/11/2015)

---

Hi all,

Just want to know if the below query can be written using the CTE

[p]DECLARE @C INT = 0;

DECLARE @G INT = 0;

DECLARE @H INT = 0;

DECLARE @I INT...

Then you need to check for 1, 0 or NULL (Those are the only values a bit can have).

when status_ID = 0 and flg_attendance =...

Also a bit off topic but I notice you using the NOLOCK hint on your queries. This hint is very often used incorrectly because the person writing the code does...

Abu Dina (11/10/2015)

---

Just wanted to say hello.

I've joined the dark side so been using Oracle (and a bit of Sybase ASE) for the last 18 months.

I miss SQL Server so...

Ed Wagner (11/10/2015)

---

Sean Lange (11/10/2015)

---

Iwas Bornready (11/10/2015)

---

I had to check the table structure of sysjobschedules. I would never have guessed that a date column was put into a purposely constructed...

That is not a custom function. It is a...

For some reason MS...

Jeff Moden (11/9/2015)

---

Rich Mechaber (11/9/2015)

---

Jeff Moden (11/6/2015)

---

sknox (11/6/2015)

---

Luis Cazares (11/6/2015)

---

Rich Mechaber (11/6/2015)

---

Aaron Bertrand had a nice blog about this: scroll down for "Pop Quiz" and see if you still think...

Lynn Pettis (11/6/2015)

---

Here is a posting for a SQL Database Administrator. I've looked it over several times. Please tell me where it says anything about PostgreSQL besides in...