Topics
Started by
Posts
Last post
Okay, I'm banging my head against the wall on this one. I am querying XML data, which the data and…
11 replies
1Green 2Yellow 3Yellow 4Pink 5Green 6Yellow 7White 8White 9Pink I want following output 1…
7 replies
The below is a simplified version of what I am trying to do. I have a job table which has a jobID.…
7 replies
Hello, I have a database of students' grades, however some are numeric and some are alpha. Dependin…
7 replies
Hello, I'm trying to modify the following command with TRY/CATCH blocks. When the department alrea…
1 replies
i created a CTE which finds a subset of records from a table I then ran a SELECT statement against …
11 replies
Which clause of the MERGE statement isn’t standard? a. The WHEN MATCHED clause B. The WHEN NOT MA…
17 replies
I am having an issue with dynamic sql. I am getting this error: Msg 402, Level 16, State 1, Line 27…
12 replies
Hello, I need help with a sql query. CREATE TABLE #Orders ( OrderID INT, ProjectID INT, ProductI…
76 replies
Hello everyone, Please help to get the desired results for the following sample data set. I was abl…
18 replies
I have the following table: create table #address (address_id int, addr1 char(30), addr2 char(30), …
4 replies
I am having a table with around 60000 rows. When updating, it takes long time to finish. My table d…
35 replies
I am sure this is a very rudimentary question, but I have "googled" and searched and cannot figure …
4 replies
Hi All, I have a problem described as follows: I have a table with one instead of insert trigger: c…
5 replies
I would like to get extract the first row of some time based data where any of the other values cha…
15 replies
Viewing 15 topics - 3,166 through 3,180 (of 4,984 total)
You must be logged in to create new topics.