Topics
Started by
Posts
Last post
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
Here is my Sample Data (Below SQL For Create Sample Data) ID,Fname,Lname,Amount,Visit 1,Smith,D,125…
12 replies
hello I have setup Database mail on my SQL Server 2012. I have been successful in generating daily …
2 replies
Viewing 15 topics - 3,166 through 3,180 (of 4,984 total)
You must be logged in to create new topics.