Topics
Started by
Posts
Last post
Hi All, I am working on a report that demonstrates how much time a room is on use between parameter…
3 replies
Hi All, I'm using SQL Server 2008 r2. I have a table with lots of dates, some in the past, some in…
4 replies
Hi I think I should be able to do this with a single query using OVER clause, but I cannot get it t…
3 replies
Newbie here. Having trouble with a multi-table join exercise, code below. A two-table join works fi…
4 replies
I need help to write a query like below oupt put. create table #table (id int, cid int , startdate …
16 replies
Hi All, I am working on the below requirement. use css go create table test ( eno int, t1 int null,…
4 replies
I've been using SQL Server 2008 R2 for my web development for years and it's been working perfectly…
6 replies
Hi, I have a table where I want to filter out some records. I want to get maximum OF enddate BY U…
1 replies
Hi how can I archive to SELECT * INTO existing table without listing column names?
4 replies
Hi all, DECLARE @batchSize INT Declare @siteid nchar(3) DECLARE @Instanceid nchar(3) set @siteid =…
3 replies
Hi I wanted to run a job nightly that would delete folders within a folder that where older than 3 …
2 replies
Hi there, I need to join onto a table (Class_TB) twice because one of the conditions (Airline_FD) c…
5 replies
Hello, I am learning SQL and wondering if someone can help me with script below – not sure if I am …
13 replies
In t-sql 2008 r2, I am trying to determine how to setup the sql to accomplish the following goal: s…
8 replies
Can someone tell me how to dynamically populate my in these nested cursors to reflect the current …
9 replies
Viewing 15 topics - 2,476 through 2,490 (of 10,635 total)
You must be logged in to create new topics.