Topics
Started by
Posts
Last post
1) My DB is corrupt with this error: Msg 8947, Level 16, State 1, Line 1 Table error: Multiple IAM …
5 replies
Hi, Could you please suggest the index on table(dbo.person) that can fast my below sql.. select Re…
4 replies
I have a parameter query dataset returning CallType, CallTypeName, CallType + " - " + CallTypeName …
11 replies
I need to come up with a way to uniquely define how data will appear on the different parts of the …
2 replies
Hi, Trying to get a structured XML extract from a dataset, some of the columns have the "&" si…
5 replies
We have a default instance installed and have 3 named instances which are running on different port…
2 replies
In a clinic we need to find how many visits a doctor got from each patient each day. A simple group…
6 replies
We have a job which runs daily at 8 AM in the morning but sometimes, the job is disabled and for da…
4 replies
I've following trigger to "move" record just updated on Data_Canc to a shadow copy of same table. T…
10 replies
Hi I am having trouble with a where clause on a sub query (or left join eventually) This works... …
11 replies
If have the following code that is called by triggers to update data in a parent table. It is used…
13 replies
Morning, I have a table that looks like this: INSERT INTO TEST (COL1,COL2,COL3,ITEM1,DESC1,ITEM2,D…
5 replies
Hi , I need help in a scenario that i am working on where i have to convert rows to columns , i …
3 replies
I have an issue where an occurrence (incident) can be categorized into multiple types. What I am tr…
4 replies
Hi Team, I have an XML as below. and I am trying to load that xml to a SQL Server table using t-sql…
2 replies
Viewing 15 topics - 2,311 through 2,325 (of 4,984 total)
You must be logged in to create new topics.