Topics
Started by
Posts
Last post
I have a script that retrieves Job Scheduling information. I want to order by Date and Time. Here i…
3 replies
I have 2 CTE . I want to use value from 1st and 2nd CTE in my 3rd CTE . Is it possible ? With CTE1 …
5 replies
In a sql server 2008 r2 database, I am trying to take the results of the cte called sProgram and jo…
5 replies
By: SQLRNNR
hi All, i have a query like this. i want to rewrite as single query use WHERE EXISTS and NOT EXISTS…
1 replies
Is there an option to NOT return a query set in a stored procedure (conditionally)? So I have my sp…
3 replies
The table in question has ~100 million rows and an index on the Date column. For some reason...my d…
4 replies
Hello all, I have to change the datatype of a column in all tables of a database where that column …
4 replies
Hello Everyone, I have scenario where if an employee has a Sick right before or after the Holiday h…
4 replies
I have the following table that I need to get a median for one of the columns mytable State Ci…
11 replies
Hello, I have a stored procedure: Alter proc ddGetDevStatsByUnitStateAndYear (@Unit varchar(20), @…
8 replies
Hello, In brief, the query below is generating the error given in the post subject line. I have re…
9 replies
Hi all, I have a query that looks something like this: select a.Id, cast(isnull(B.answer,0) as nume…
6 replies
Hi, I have 5 union queries which have repetitive Not in clause. Can I exclude these using CTE Pleas…
12 replies
Greetings everyone, First of all I hope the Post Title is accurate as to what I'm asking your help …
5 replies
Hi, I want to take Report from every month 26th(it may be last or current month) to Day-1 o…
4 replies
Viewing 15 topics - 2,371 through 2,385 (of 10,647 total)
You must be logged in to create new topics.