Extra FROM

select top 10 * from

from

Maybe you could set up a trigger to do the second part of the processing during the inserts.

Best example I have seen on the web. It actually works if you follow the steps.

Shouldn't the whole Set @SQL = be into quotes?

Set @SQL = 'Insert and so on'

This is one the first page of the scripts forum and I'm thinking you can convert it from commas to pipes.

http://www.sqlservercentral.com/scripts/String+Manipulation/71602/

Good explanation...Thanks!

What tags did you use?

Sorry about the formatting. I must have used the code tags wrong. 🙂

Our friendly DBA here at work got it working for me. Looks like my biggest mistake was not specifing the database in the connection string. Here are several...

jrbass81 (8/23/2010)

---

getting "incorrect syntax near '3'.

can anyone figure out WHY??

CREATE procedure [dbo].[TRACKIT_SUMMARY]

AS

BEGIN

declare @DOW int

select @DOW = DATEPART(weekday,getdate())

if @DOW = 2 -- Monday

select

...

I’m not a DBA, I’m in applications and I’m trying to report on what users are in what roles. The structure is there are roles set up as job...

Here's some good information on rounding. Maybe you can use one of the functions in Excel or convert one to SQL.

http://support.microsoft.com/kb/196652

That’s what I said a few posts ago. There is a bug along these lines in SQL 2005 (below). I think there is a patch for it.

set...

middletree (5/4/2010)

---

This has probably been asked before. Small company, the former IT people long gone. A SQL Server 2005 database exists, but there's no record of any loginname/password, including sa....

umbelgul (3/22/2010)

---

hi!!

i am new to sql server 2005 ,but dnt know how to use,any one can guide me from scratch. i want to use sql server 2005 with visual...