Topics
Started by
Posts
Last post
Hello, Please help me here with below Query SELECT AcctNo, PlanCount = COUNT(Model_no), PlanName =…
2 replies
I have two CTEs sharing same column names and I need to combine their results into one result set. …
26 replies
Is it possible to use a stored procedure to kill all queries running longer than 2 hours AND are bl…
10 replies
Hi, I have a scenario in which I am performing insertion on a table using a stored procedure. For e…
50 replies
i need to create a query on a table where the condition is such that we select the rows where the v…
3 replies
There is a heap like the one shown below: USE tempdb; CREATE TABLE Heap ( [Column 0] NVAR…
4 replies
Morning all, Could someone help me generate the following grouping please? Sample data plus expecte…
8 replies
I have a stored procedure : In this prcedure I am returning @pSTN value and used in another sp as …
12 replies
Hi All I have a function that works in one database but not another. Both databases are SQL2008 R…
3 replies
Hello All, please help me with this single select statement, StudentNew table is exist with below v…
10 replies
I figured it out....Thank you, I would like to return all the data for a single empnum, but this qu…
6 replies
Hi, This is related to the table and query in question: http://www.sqlservercentral.com/Forums/Topi…
7 replies
This is my first shot at an trying to unpivot multiple columns, and I'm not getting any results. I …
2 replies
Hi, I found an SP that generates multiple index seeks from 1 case statement. By the looks of it eac…
6 replies
Hi all SQL gurus... I need help in creating a query without any funtion to do merge owner's names f…
1 replies
Viewing 15 topics - 3,721 through 3,735 (of 10,647 total)
You must be logged in to create new topics.