That looks pretty decent. I would suggest that you shouldn't store the number...

Wha????

It does not store formatting. It allows for storing...

Grant Fritchey (1/14/2014)

---

Sean Lange (1/14/2014)

---

Here is a true story from the field that a buddy of mine shared with me yesterday.

Yesterday my supervisor sent me an email regarding a view...

Have you investigated parameter sniffing? The symptoms you describe sound like that might be the issue.

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/%5B/url%5D

Skuldouggery (1/14/2014)

---

Yep, I am using SSMS. The setting is at max too. My problem is that this was working last week and returning the output to the xml_col...

Skuldouggery (1/14/2014)

---

The script without the xml portion runs fine, as you noticed. However, with the xml portion, the script returns only the first record from the BETWEEN statement, and...

j-1064772 (1/14/2014)

---

[font="Comic Sans MS"]So the optimizer IS actually using the equivalent from Boolean algebra ?[/font]

As I wrote before:

[font="Courier New"]WHERE NOT (ProductID = 1 OR ProductID = 2 OR ProductID =...

j-1064772 (1/14/2014)

---

[font="Comic Sans MS"]Thank you all for your inputs, I now understand what INTERSECT and EXCEPT bring to the party.

I am however still trying to understand why the following occurs:[/font]

[font="Comic...

S_Kumar_S (1/14/2014)

---

Hi

I have a resultset returned from a select statement :

Name FirstNamePhone

Test1-LTest1-FGermany

Test2-L Test2-FGermany

I want to convert it like :

SELECT 'Test1-L' Name ...

Steve Jones - SSC Editor (1/14/2014)

---

Sean Lange (1/14/2014)

---

Here is a true story from the field that a buddy of mine shared with me yesterday.

Goes to show that you should leave...

sqlnaive (1/14/2014)

---

I am trying to write a dynamic query within a while loop and executing it like this

create table #temp(Col1 varchar(20))

declare @p nvarchar(max), tabname varchar(255)

while @a <= @b-2

begin

select @p...

Take a look at this article. http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D

It explains how to use the "quirky update" for running totals. Make sure you pay attention to the details as there are some extremely...

ashley.shookhye (1/14/2014)

---

Hi Everyone,

Just want to output my result in a better way. Below is the query I am using where I am a doing a join and a union. I...

I suspect you want to count the children plus the children's children etc? This is a hierarchy and can be solved using a recursive cte. You can either use your...

What you have here is a running total problem. This is reasonably easy to solve using a "quirky update". You can read about them here. http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D

Please make sure you very...