Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by djj55
-
Survey says: Most annoying word of the 2016.
Whatever. djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!- djj55
- Post #2
- Forum: Making an Impression
-
Vanity Plates "XVII"
On newer SUV 80S METL djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!- djj55
- Post #33
- Forum: Making an Impression
-
Looping through a table to find records
I assume your table has a indexed time column as SQL Server does not always store records in the order they are created. djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!- djj55
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Vanity Plates "XVII"
On a lime green Ford Festiva KRYPTN djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!- djj55
- Post #32
- Forum: Making an Impression
-
Vanity Plates "XVII"
On a Mercedes-Benz SUV B U TFUL djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!- djj55
- Post #31
- Forum: Making an Impression
-
Deadlocks
Have you looked at fragmentation and last update of statistics? djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!- djj55
- Post #2
- Forum: Microsoft SQL Server: Setup and Administration
-
Business Titles
Or he wanted to shade his neck. [wink] djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!- djj55
- Post #11
- Forum: Making an Impression
-
Vanity Plates "XVII"
On a motorcycle VAPE1 The person was wearing a shirt for an electronic cigarette store. djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!- djj55
- Post #20
- Forum: Making an Impression
-
Way to switch to a different database from queries.
You will need dynamic SQL for this, if I am reading your post correctly. By using johnherman suggestion you can create the code you need djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!- djj55
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Vanity Plates "XVII"
On a pickup truck 3TWO1 GO djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!- djj55
- Post #19
- Forum: Making an Impression
-
ifnull
There is also the NULLIF function NULLIF djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!- djj55
- Post #7
- Forum: Microsoft SQL Server: Programming
-
Use of Get vs Gets
Get it, got it, good. It would help if there were fewer exceptions in English. I believe this has been discussed before. Not sure though. djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!- djj55
- Post #16
- Forum: Making an Impression
-
Vanity Plates "XVII"
Not real sure what this means but I like to think back at IT: BK AT IT djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!- djj55
- Post #12
- Forum: Making an Impression
-
Select latest status with condition... help please
May not be the best way but... WITH cte AS ( SELECT Network_id, Status_Code, Status_Time, ROW_COUNT() OVER(PARTITION BY Network_id ORDER BY Status_Time DESC) AS rcnt ) SELECT Network_id, Status_Code, Status_Time FROM cte WHERE rcnt = 1; djj The Lord is my shepherd (Psalm 23) - I need someone...- djj55
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Percentage Question Total Records Issue
If I understand you might try COUNT(DISTINCT Owner) djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!- djj55
- Post #2
- Forum: Microsoft SQL Server: Programming
