Topics
Started by
Posts
Last post
Hello all, I have a select statement something like this. SELECT .... COALESCE ( here I take the fi…
12 replies
Hi Guys, I am trying to get this result, can anyone give a lead or clue how to achieve this? Rep …
10 replies
We currently have the stored procedure setup to allow to lookup of a supervisor as of a particular …
2 replies
Hi all- I posted this question earlier and received a solution to create a CTE: see--> http://ww…
17 replies
Hi All, I ended up with 1 out of 8 databases blocked. When I ran the SP_WHO2, I found that the dat…
2 replies
Here is the scenario, we have a Customer DB that has duplicate Customers with different CUSTID valu…
8 replies
Hi, SELECT TOP 5 total_worker_time/execution_count AS [Avg CPU Time], SUBSTRING(st.text, (qs.statem…
4 replies
Hey everyone! Hoping you can help me with a sql query problem I am having. I am creating a query ag…
3 replies
I have a table. I want to pivot this table rows. Attached is the excel containing the input table f…
1 replies
Hi All, I'm trying to do something like this: INSERT tblArchive (Col1, Col2, Col3) OUTPUT …
10 replies
Hi, i have a table called Table a CREATE TABLE [dbo].[TableA]( [ServerName] [varchar](100) NULL, …
3 replies
Hi, I have a query and want your help with it. -----------------Question ------------------------ …
2 replies
Trying to generate a T-SQL script for create view, if it does not exist. Instead of the traditional…
10 replies
I'm stuck with 2008 R2 standard edition and so I can't do true partitioning and have to use a parti…
6 replies
I have a query that update a target table by joinng this table with other 3 tables to limit records…
5 replies
Viewing 15 topics - 7,876 through 7,890 (of 10,635 total)
You must be logged in to create new topics.