Hi,

Simplest example:

declare @db_name nvarchar(50);

set @db_name = db_name(); -- gets name of current db

execute('SELECT AuditMasterID, TableName FROM ' + @db_name + '.dbo.tblAuditMasterLog')

Cheers

using REPLACE function to replace '_lid' with '&' in the substring should work too.

select

left(substring(QueryString, PATINDEX('%src=%',querystring)+ 4, len(queryString) ),PATINDEX('%&%',replace(substring(QueryString, PATINDEX('%src=%',querystring)+ 4, len(queryString) ),'_lid','&'))-1) myDesiredValue

from MyTable

Hi,

I think you should use a dedicated table for ProductLine. There may already be a natural key, that can be used as key, otherwise you could generate guid, as you...

Hi,

If you want to show rows as columns, you need to use PIVOT or CROSSTAB technique.

There are some good articles about this:

SQL Pivot and Cross Tab

Using PIVOT[/url]

Using PIVOT and UNPIVOT

I...

Hi,

My first thought would be to use least value of PATINDEX('%&%' ,querystring) resp PATINDEX('%_lid%' ,querystring).

Please let me know if the above sound unclear.

Cheers

Although this is not a SQL Server table, still, this is a SQL Server forum ;-).

So here are some links to information about normalisation, right from the vendor:

Description of the...

Hi,

Maybe reading this article will comfort you:

http://msdn.microsoft.com/en-us/library/ms189087(SQL.90).aspx

"Similarly, unless the large value types out of row option is set to ON, varchar(max), nvarchar(max), varbinary(max), and xml columns are stored,...

Hi, I don't understand your Problem #2 question, regarding Problem #1, I think you should remove RN.BEGIN_DATE from the select.

How about using the builtin newid() funcion like:

DECLARE @rand AS char(64)

SELECT @rand=replace(cast(newid() AS varchar(36))+cast(newid() AS varchar(36)),'-','')

SELECT @rand