Does it work if you do this :

if 1=0 --never true, just to show AssetID field in reporting services data grid

Here's something someone made me realize :

check out their ips :

Mr Sufian : 58.11.72.87

raj : 58.11.72.101

I'm not a network guy of any kind but that seems to come...

Yes... but I still reply to my private messages and I saw you hit the mark... so off I go again .

"(e.g. 2005-07-25 12:08:44.437). However, when the query is processed, you Check constraint is kicked off before the data is entered into the table, and this returns it's own timestamp...

Congrats on the 2K mark Noeld .

This is only for a demo... just use this code and use the right table/column names :

select *

from dbo.Temp

where substring(Test1,1,charindex('-', Test1)-1) substring(Test1,charindex('-', Test1) +1, 100)

I think this could work :

Convert(varchar(20), ReportDate, 112))

The 112 is the iso format which is deterministic. That conversion isn't deterministic because the date format of the connexion makes...

7 is just a number. If you have 2 tables with 1 B rows each and you need to get fast running queries, you might need to use a...

HTH.

Try select eachid COLLATE yourcollationnamehere from dbo.fnsplit()...

You might also have another search at the script section. There's a function called wordnumbers or something like that that will do exactly what you need without creating any...

This may be what you need :

http://www.sqlservercentral.com/scripts/contributions/612.asp

The only fun thing I know is "la ronde" which is a great amusement park. They present a worldwide fireworks competition twice a week which are reallllllly good. ...

It's a function that returns a table. Either by a straight select, or by declaring a table variable and returning that as the select. This gives you a...

I like like better... but that's just me .