Topics
Started by
Posts
Last post
Hello, I am randomly assigning agents to accounts. Currently I use a cursor, however I would like …
2 replies
I have 3 tables: News: bigint NewId nvarchar NewTitle datetime NewDate nvarchar NewBrief ------…
24 replies
Hello Everyone, I'm working on a report where my table is as follows: WITH SampleData (ID,NAME,[VA…
2 replies
Hi Guys, I'd like to find out if its possible to check what the first node is before loading an XML…
2 replies
Hi, Can you please help me on this I need to remove part of string from Address field I tried t…
5 replies
Not sure whats the syntax error here.. SET @Command = 'C:\"Program Files"\"Microsoft SQL Server"\90…
4 replies
The is query is not working as expected (or at least as I expect). There is one SSN in the VEStagin…
6 replies
Hi Everyone, I am using MSSQL Server 2008R2 and I am interested in returning rows from a 'financial…
3 replies
Hello, I want to calculate total sum of column. I have a table with many values of column: decla…
2 replies
Create Table Tab1 ( weekdate date, Aid int, Cid i nt, Cdate date ) --The number of entries…
12 replies
I have various ways of getting the parameters of a stored procedure: I have a procedure that has al…
2 replies
So, just having had to kill a couple instances of a query that was killing one of my QA servers, I …
10 replies
Any hints of how decrease CPU utilization on this one? I inherited ... SELECT DS.LocationID …
10 replies
Hi, Just came across some weird legacy code in my system where an INSERT is followed by three UNION…
9 replies
Dear All I have two similar tables in different database and need to make query to select only th…
8 replies
Viewing 15 topics - 2,056 through 2,070 (of 10,647 total)
You must be logged in to create new topics.