I am trying to use Top and count in 1 query.
select top(100) count(1) from table where name…
1 week, 6 days ago
I am using the following query to find the top 10 transaction and percentage of transaction w…
1 month ago
By: Jonathan AC Roberts
Hi guys, I read once that the inner join was better. This morning I tried to prove it and came very…
1 month, 3 weeks ago
Does anyone know syntax to use to format a date field with as follows (02/09/2009 14:34)?
Any help …
3 months, 2 weeks ago
By: Jason A. Long
I am trying to convert all our main application to use sp_send_db_mail; here is my question though;…
4 months, 3 weeks ago
I have a performance issue with a set based solution. Please could you advice me w…
By: Paul White
I have a query the returns country....state...and cities
the cities are creating ore rows…
4 months, 4 weeks ago
I need to remove DATE from a date time column in SQL 2005? All I keep finding on Google is h…
7 months ago
By: Jeff Moden
Hi, i have to build a database for my university coursework, i have 5 tables and 1 of them has 2 fo…
7 months, 1 week ago
I need to set a variable inside a Case that is inside a Select. I am using this is for counting pu…
7 months, 3 weeks ago
I have a table (let's call it TableA) with a primary key defined (let's say the column is called Co…
9 months, 1 week ago
By: Lynn Pettis
I have a stored proc that calls a web service via WinHttp.WinHttpRequest.5.1. For years, I …
10 months, 2 weeks ago
I have XML data store in Sql table. XML structure will not be static.i want write the T-sql Cod…
11 months, 3 weeks ago
Where does the Alias reside when using a CASE Statement?
I have tried a couple place…
1 year ago
I have a column which is integer data type and it represents number of seconds.
I need to co…
Viewing 15 topics - 1 through 15 (of 12,231 total)
You must be logged in to create new topics.