To be honest with you and to check my thoughts I performed the following:

CREATE TABLE #desigations(

designationname varchar(150),

accountcode bigint)

INSERT INTO #desigations(designationname,accountcode)

SELECT NULL,77 UNION ALL

SELECT 'Less',8 UNION ALL

SELECT 'Something',9999 UNION ALL

SELECT...

Nice question - a good way to start my week

I do not think it is the word "pad" that is the problem, using SQL 2008 R2

CREATE TABLE #T(Id INT IDENTITY(1,1),Title VARCHAR(30))

INSERT INTO #T(Title)

SELECT 'pad Thai' UNION ALL

SELECT 'Thai pad'...

If you have access to BOL (Books On Line - the SQL server help file) you may want to investigate the subject "SQL Server Audit Action Groups and Actions...

Thanks for a good question on fundamentals of the DATETIME data type.

As long as a company has not been "burnt" , that is has not lost a significant number of $$ by an injection attack, then the cost savings of not...

Chad Crawford (11/17/2011)

---

Wahoo! Just passed the MS 70-453 test, making me a MCITP for SQL 2008 just in time for 2012 to come out. 😀

Very happy - Passing...

Definitely test, and test again, and when you believe the results are correct - test again...

Use a CTE, for example:

CREATE TABLE #T(Date_Stamp DATETIME,KW1 DECIMAL(5,1), KW2 DECIMAL(5,1))

INSERT INTO #T

SELECT '12/10/2010', 5.3, 3.1 UNION ALL

SELECT '12/10/2010', 5.3, 3.1 UNION ALL

SELECT '12/9/2010', 4, 2 UNION ALL

SELECT '12/8/2010', 3,...

Why thank you for the compliment, it made my morning joyous.

Hugo Kornelis (11/15/2011)

---

Good questione, but the explanation is a bit too short. I assume Ron intended to write "You cannot create a named constraint on a table variable". On temporary...

Here is a good place to start:

http://www.simple-talk.com/sql/learn-sql-server/sql-server-index-basics/

Phil Parkin (11/14/2011)

---

Hehe.

Here's how it's done in SSIS.

1) Add a data flow task.

2) Add an OLEDB source connection to the DF.

3) In the connection manager settings for the OLEDB source,...

quillis131 (11/11/2011)

---

I tried out some Tsql Format for the query ... Its was just getting what i need ... but It doesn't sound good for SSIS ... I guess...

First of all realize that there is not a "next row", in a SQL table, rows are not guaranteed to be returned in the order in which they were added...