Well you've come to the right place 😀

Glad to help

Just place a comma "," after nName

Name as nName,

I am trying to run the following query:

select Name, PracticeAddressFirstLine from GlobalOrganization where PracticeAddressState = 'TX' group by practiceaddressfirstline order by Name

I get the following error:

Msg 8120, Level 16, State...

I am trying to run the following query:

select Name, PracticeAddressFirstLine from GlobalOrganization where PracticeAddressState = 'TX' group by practiceaddressfirstline order by Name

I get the following error:

Msg 8120, Level 16, State...

Glad to help

[/size]

Thanx for that Steve... This is a great piece of code.

This is what we use, and works just fine:

http://www.codeproject.com/KB/vb/SQLVBCoder.aspx

select *

from information_schema.routines

Select*

From Information_schema.Tables

We use CodeGen which automatically generates update/insert/delete etc SP's for each table

We experienced simmilar issue:

Packages designed in 32bit, then migrated to 64bit does not work.

Solution:

1. Open dtsx package on VS on 64Bit

2. open up all "Script Tasks" into "Design Scripts"

3. Save...

declare @year char(4)

Declare @visa varchar(25)

declare @visa1985 varchar(25)

Set @year ='1985'

set @visa ='56'

set @visa = '@visa' + ''+@year+'' +'=' + @visa

select @visa

Hhmmm, very unique situation!!!

But like all SQL queries, they usually are.

"So I have been looking at using a ServerName Column (default value @@ServerName) and a Identity Column (Auto Number) as...

Hi Brad,

I think we might need a little bit more info on this, but if I understand you correctly:

1. You send out a copy of the MASTER Db to remote...

Hi my fellow SQL-Freaks.

On this topic: Reading Email on 64bit SQL 2005

Currently we also run 64Bit SQL 2005, and same as you, as a DBA and Analyst, I also needed...