Topics
Started by
Posts
Last post
Hi I gto different servers whose names start with MSX like MSX001, MSX34, MSX674 and so on.. Now i …
1 replies
I have this query where each select runs very fast, approx 1 to 2 seconds on a table with almost a …
19 replies
We had a SQL statement that is similar to the following on SQL 2008 R2 (10.50.1600) on a 64-bit ser…
1 replies
I need to format the output of a query to XML. There are only two columns in the output: tblCatego…
3 replies
I want to execute a SP in all databases, I have 40 Dbs on a server, Cursor executes, sometimes for …
1 replies
Hi All I have a sp that has 100 columns where I perform the same CASE and function call on each of …
3 replies
Is it possible to issue multiple DML statements via one EXEC command? I have a linked server (Micro…
17 replies
Hello all, I am in a situation where i need to find a particular string in an xml file 'itemid 285'…
2 replies
Hi Guys., stored Procedure : USE [TMSLocal] GO /****** Object: StoredProcedure [dbo].[GetUpcomingE…
1 replies
Hi, Please give me good solution as below SQL statement, application gets error - Timeout expired. …
10 replies
Here is my query I need to get All in the first row and the remaining in the alphabetical order sel…
1 replies
I do the SQL Support on what is the worst written app I have seen in 30 years in the business. It'…
2 replies
Hello, I have a value change log table. CREATE TABLE #LogTable ( CustomerID int , LogDate date…
1 replies
Hello SQL Server Community, I am trying to come up with a sql statement that will return only the r…
5 replies
Hi I am trying to do an insert into a table (employer) where I am grabbing a max date from another …
2 replies
Viewing 15 topics - 8,026 through 8,040 (of 10,647 total)
You must be logged in to create new topics.