Topics
Started by
Posts
Last post
In a sql server 2008 r2 database, I am trying to take the results of the cte called sProgram and jo…
5 replies
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
Hi, I wrote a SP to pass a value to SP. It works well ALTER PROC [dbo].[getCompleteItems] (@p_ItemI…
5 replies
I am trying to assign the number of days from the beginning of a program to an event in that progra…
8 replies
Viewing 15 topics - 2,371 through 2,385 (of 10,635 total)
You must be logged in to create new topics.