Like others have said, it will take some time to learn the basic so learn, learn, learn... practice, practice, practice and you'll figure out what you love.

Whatever you do,...

ypeng5 (11/4/2015)

---

I have a table with thousand of queries are waiting for execute in sql server. I am using an store procedure to execute those queries one by one. Is...

Play around with/get comfortable with FOR XML. There are 4 FOR XML methods, RAW, AUTO,EXPLICIT, PATH once you are comfortable with them you can export data into any XML format....

Here's a couple solutions (if I'm understanding this correctly).

The caveat here is that I'm understanding you problem, which I think I am.

If you can create an inline table...

Sergiy (11/4/2015)

---

I would suggest (if NOLOCK is a requirement) to use NOLOCK, not WITH (NOLOCK).

NOLOCK without brackets is not a hint, but a table name alias.

So, the query would be...

As Lynn said, you probably don't need a cursor.

That said, you have no THEN statement in your CASE. A WHEN must be followed by a THEN.

To get values that exist in one table that do not exist in another you want to do an anti-join. You can accomplish with using WHERE NOT IN or WHERE...

I'm sorry. I misunderstood your question. Like I said, I'm unfamiliar with SIOS and DxEnterprise. 🙁

Eirikur Eiriksson (10/30/2015)

---

jasona.work (10/30/2015)

---

Brandie Tarvin (10/30/2015)

---

Someone needs to have a talk with that David Burrows guy. He's talking crazy in another thread. Like suggesting I could use SQL Server tables...

Just to clear something up. You absolutely can use an alias inside a SQL query but only after the alias has been created. It's important to clear that up.

SQL...

Michelle-138172 (10/30/2015)

---

I've been searching info on sql server clustering for 2014 standard edition on AWS, but it hasn't come up with a lot of options. Are there not many companies...

Thanks Mr. Livingston. I just installed and played around with both of Jeff...

Phil Parkin (10/29/2015)

---

Alan.B (10/28/2015)

---

Hi folks. I needed to write a stored proc that takes generates a string of random characters @minlen to @maxlen characters long for testing some functions. What...

allnelsons (10/28/2015)

---

So, question about these splitter functions (which are pretty much the most used tools in my arsenal, btw!), are they faster/more efficient being run from the I.B.G. CTE tally...

an even correcter answer would be:

It depends

(5 with a case insensitive collation, three if the collation is case sensitive. )