Topics
Started by
Posts
Last post
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
HI All I have a requirement like, we are having one city table in our database in that Records are …
6 replies
How can I convert the following string to date time data. July 7 2011 12:47 pm EDT I need to conver…
5 replies
hi everybody, can I ask why i dint get any result from this query SELECT title FROM db…
2 replies
Viewing 15 topics - 7,891 through 7,905 (of 10,647 total)
You must be logged in to create new topics.