Use the App_Name function - check it out in Books On Line

GilaMonster (5/15/2009)

--------------------------------------------------------------------------------

Ahhh!!!! Damn it! Twice this year!

Flat broken into again last night. Among other things, took the zune that I bought to replace the ipod that they stole last bloody...

For SQL 2000 this will list all users, their permssions and the roles to which the user belongs. Probably more than you require, so modify to suit your exact...

1. May I ask why are you killing these processes? I believe it would be better for you to ascertain why they are being excessively delayed, and then...

A visual studio (VB and I presume C#)

Returns an integer specifying the start position of the first occurrence of one string within another.

Public Shared Function InStr(_

ByVal String1...

Let me define what I understand a Developer task - who who develops interface code NOT...

Steve a rather timely editorial ... listening to CNN broadcast this morning. Salient points --

1. FAA (Federal Airtraffic Authority) had someone hack into one of their networks...

Christopher

Note that Jeff Moden is rewriting the article and the original is not available.... HOWEVER if you scroll down to the bottom of what is there you will find a...

Have you looked at row numbering? Selecting from below where Rowno = 1 to insert into your new table. For example:

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

(Partition by...

First - does the Excel workbook exist in the path specified? If not .create it.

Second - does it have in Row 1 column names? If not, note the...

Speaking of security here is some news posted on the BBC web site that might help in storing passwords and encryption keys and yet have the same readily available in...

What GSquared is trying to tell you

I can't quite tell, but it looks like your first Case checks for the presence of a comma, then runs a charindex on...

A good explanation along with sample code and resulsts for bit masking is in BOL at:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/20275755-4fa7-47b1-a9be-ac85606d63b0.htm

and:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/f38f0ad4-46d0-40ea-9851-0f928fda5293.htm

and

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/02da8016-f6c0-41ae-8d59-33eaa02bfc95.htm

Not knowing all that much about your application, table size etc have you looked at Full Text Searching? If not you might want to start in Books On Line...

GSquared ... think you left out the FROM table clause

;with CTE (Row, ID, MostRecent, Ben) as

(select row_number() over (partition by ID order by Date desc),

ID,

Date,

Ben FROM yourtablesname)

select ID, MostRecent, Ben

from...