Charles Kincaid - let me take you further back onto memory lane, we replaced the 709 with a 1401... Remember when coding was not accomplished with a word processor, or...

If you need to ignore the suggestions of Bob Hovious and Jeff Moden look at this code and decide what you want to do.

CREATE TABLE #Demo(Col1 VARCHAR(9),Col2 VARCHAR(9))

DECLARE @Blanks VARCHAR(9)

DECLARE...

A rather simple article, but the suggestion to pick out a few key users sounds as the way to go... you show one or two of them, and they in...

Took a while before I got up enough courage to post to this forum but here goes.

Started in '50s - college degree in Mechanical Engineering - when engineering was the...

This might give you an idea, as it is, it is rather crude

DECLARE @CEFDT DATETIME

SET DATEFORMAT ymd

SET @CEFDT = '20091017'

DECLARE @It VARCHAR(15)

DECLARE @is VARCHAR(2)

SET @It = (SELECT DATEPART(yy , @CEFDT))...

Darn GSquared types too fast for me to keep ahead of him. OH well for what it is worth here is my adaptation of GSquared's recommendations.

Without the table definitions here...

Tara-1044200

To receive some help please help us to help you. Read both the articles in my signature block and post the requested information. Other wise the only answer...

sihaab

Switch to using GOOGLE mail for e-mails from SSC read this:

http://www.seroundtable.com/archives/000784.html

and then:

http://toolbar.google.com/gmail-helper/notifier_windows.html

It will cause a small window to open up just above your tool bar and displays for...

No not at all close to the same thing. Using a group by with the HAVING clause

SELECT lngCompanyID,shtCompanyID,dtmModified, COUNT(*) AS...

Try this:

;with numbered as(SELECT rowno=row_number() over

(partition by lngCompanyID,shtCompanyID,dtmModified order by lngCompanyID)

, lngCompanyID,shtCompanyID,dtmModified,strAddress from #tDupData)

select * from numbered

Resulting in:

rownolngCompanyIDshtCompanyIDdtmModified strAddress

11 ...

Be aware of some gotchas when using SET IDENTITY_INSERT ON. For example:

CREATE TABLE #Tident(ID INT IDENTITY,Col1 VARCHAR(5))

INSERT INTO #Tident

SELECT 'A' --repeated for a total of 7 rows

This...

You may have other syntax errors but from Books On Line.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/01de7476-4b25-4d58-85b7-1118fe64aa80.htm

The names of users that are mapped to SQL Server logins, certificates, or asymmetric keys cannot contain the backslash character...

Not knowling exactly how your T-SQL statement are composed you might think of creating a function based on either East Coast time minus some hours or Greenwhich mean time minus...

This works for me:

SELECT * INTO Dbo.ICSV

FROM

OPENROWSET('MSDASQL',

'Driver={Microsoft Text Driver (*.txt; *.csv)};

DEFAULTDIR=F:\Testdata\;',

'SELECT * FROM CSVFile.csv')

SELECT * FROM dbo.ICSV

As far as I can tell all I did to your code that was...

If you have not read this article by Gail Shaw, I suggest you do so.

http://www.sqlservercentral.com/articles/64582/

and by Paul Randal

http://www.google.com/reader/view/?tab=my#stream/feed%2Fhttp%3A%2F%2Ffeeds.feedburner.com%2FPaulSRandal

Randal's blog post also contains links to several additional articles in Technet magizing...