SQL Kiwi (11/29/2012)

---

dwain.c (11/29/2012)

---

So how about an...

We have a new client coming on line next year with a potentially, really high volume SQL 2008 database in which I anticipate many, many performance issues. I think...

Jeff Moden (12/20/2012)

---

SQLJocky (12/20/2012)

---

One of our developers created this UDF to trim out special characters...is there a better way to do this?

ALTER FUNCTION [dbo].[UDF_TrimSpecialCharacter]

(

-- Add the parameters for...

And thank you Neha05 for stopping by, having a read and commenting.

Cadavre (12/3/2012)

---

CREATE TABLE #yourTempTable([MonthName] VARCHAR(9), [Year] INT);

WITH CTE(N) AS (SELECT 1 FROM (SELECT 1 UNION ALL SELECT 1)a(N)),

CTE2(N) AS (SELECT 1 FROM CTE x CROSS JOIN CTE y),

CTE3(N) AS (SELECT...

GSquared (12/18/2012)

---

Here's one way to do it in T-SQL:

DECLARE @String VARCHAR(8000) = 'ABC12D34E56';

WITH Seeds(Seed)

AS (SELECT ...

This can also be done using the PatternSplitCM function described in the fourth article in my signature line (Splitting Strings Based on Patterns).

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

...

Lynn has pointed you at a catch-all query that will work as you have indicated. But you should also read this article SQL in the Wild - Catch All...

My first suggestion to you would be to remove the tbl_ from your table names as I find that convention totally annoying. You're not programming C or C# here,...

Why not just drop the schema name entirely from the query?

Or query the schema name ahead of time and then conditionally execute the query, either with or without the dbo....

+100% (agreement). Merry Christmas Jeff!

Very cute Vinu! Cheers to you too.

vinu512 (12/24/2012)

---

dwain.c (12/24/2012)

---

vinu512 (12/20/2012)

---

dwain.c (12/20/2012)

---

Looked like a...

Jeff Moden (12/23/2012)

---

I don't know about the rest of you, but the amount of SPAM posts on SSC seems to be growing. I even got SPAMmed on my PM...

vinu512 (12/20/2012)

---

dwain.c (12/20/2012)

---

Looked like a single quote...