Viewing 15 posts - 2,536 through 2,550 (of 3,221 total)
Use the App_Name function - check it out in Books On Line
May 15, 2009 at 2:56 pm
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...
May 15, 2009 at 10:32 am
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...
May 12, 2009 at 5:57 pm
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...
May 12, 2009 at 3:33 pm
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...
May 12, 2009 at 3:08 pm
Steve Jones
This thread was designed to highlight things that developers commonly do wrong
Let me define what I understand a Developer task - who who develops interface code NOT...
May 11, 2009 at 11:54 am
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...
May 7, 2009 at 2:23 pm
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...
May 7, 2009 at 12:24 pm
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...
May 4, 2009 at 9:43 am
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...
May 2, 2009 at 10:38 am
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...
April 29, 2009 at 10:53 am
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...
April 29, 2009 at 10:09 am
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
April 28, 2009 at 8:54 am
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...
April 25, 2009 at 8:57 am
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...
April 24, 2009 at 10:08 am
Viewing 15 posts - 2,536 through 2,550 (of 3,221 total)