Viewing 15 posts - 856 through 870 (of 3,221 total)
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...
November 21, 2011 at 10:44 am
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'...
November 20, 2011 at 5:24 pm
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...
November 18, 2011 at 1:16 pm
Thanks for a good question on fundamentals of the DATETIME data type.
November 17, 2011 at 9:23 pm
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...
November 17, 2011 at 3:33 pm
Chad Crawford (11/17/2011)
Very happy - Passing...
November 17, 2011 at 1:37 pm
adrian.walsh 56299 (11/17/2011)
Oooh Powerful!I need to test more, but I think I like this CTE.
😀
Definitely test, and test again, and when you believe the results are correct - test again...
November 17, 2011 at 11:34 am
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,...
November 17, 2011 at 9:14 am
Ninja's_RGR'us (11/15/2011)
I love the new question style Ron! Nice way to do this :cool:.
Why thank you for the compliment, it made my morning joyous.
November 15, 2011 at 6:14 am
Hugo Kornelis (11/15/2011)
November 15, 2011 at 6:04 am
Here is a good place to start:
http://www.simple-talk.com/sql/learn-sql-server/sql-server-index-basics/
November 14, 2011 at 9:18 pm
Phil Parkin (11/14/2011)
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,...
November 14, 2011 at 8:03 am
quillis131 (11/11/2011)
November 14, 2011 at 7:42 am
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...
November 13, 2011 at 4:03 pm
Viewing 15 posts - 856 through 870 (of 3,221 total)