Topics
Started by
Posts
Last post
hi can someone tell me why select * from ( select '01-jan-1900' as DayBase union select GETDATE(…
10 replies
Hi Today, I was working on creating a disk space monitoring utility in one of our test environment …
5 replies
[font="Courier New"] I need to filter an ordered result set based on the first occurrence of a uniq…
6 replies
Hi everyone, I have the following table create table temp (status int,name varchar(20)) insert tabl…
3 replies
I am extracting data from tables to export into an Excel spreadsheet. One of the columns has a data…
9 replies
Hello, I'm looking for an answer that seems relatively simple; however, my brain is blocked. I'm lo…
3 replies
I have the the following code (last few lines). I'm able to come up with a correct SQL Statement bu…
3 replies
Hi Can anyone tell me what the 0 does in the following: SELECT DATEDIFF(m, 0, '01/01/2011'); Does i…
4 replies
I'm trying to assign a string to a variable that contains a Quote and I can't recall the syntax. Ob…
1 replies
I am getting the following error when trying to restore a backup file from msdb: Msg 3168, Level 16…
7 replies
Hey, i wonder what's the most efficient way to get a "rank" of a record in a table set. An example:…
2 replies
I have 6 fields: Eg ID,dept,sum1,sum2,total and company I have 6 distinct companies, I need to cr…
1 replies
I've been given a task to create a query to return 3 years of sales data in monthly aggregate forma…
7 replies
Hi, How can we compress specific tables in a database. Please helpme out In advance thank you 🙂
3 replies
I have a table that contains items in the pipeline that are being manufacture at different times bu…
7 replies
Viewing 15 topics - 7,036 through 7,050 (of 10,647 total)
You must be logged in to create new topics.