Topics
Started by
Posts
Last post
In t-sql 2008 r2, I am trying to determine how to setup the sql to accomplish the following goal: s…
8 replies
Can someone tell me how to dynamically populate my in these nested cursors to reflect the current …
9 replies
Hi, we have numerous scripts in place to track job failures etc. But I've noticed a few times that …
4 replies
Using SQLServer2008R2 10.0.5841 create table t (c1 int primary key, c2 int, c3 as 1*2) insert into …
2 replies
I am using Data Compare which does the following: UPDATE [dbo].[EmployeeImage] SET [ImageData]…
4 replies
How can the following code be rewritten so it looks like a list rather than repeating Not Like ... …
3 replies
hi i need to capture column name using trigger for a table which are getting changed For Ex: Create…
9 replies
here is a sample table DECLARE @t TABLE(a INT,b INT,c INT); INSERT @t VALUES(1,2,3),(9,8,7),(4,6,5)…
1 replies
i have TABLEA and TABLEB Table A: Create table TableA (ID INT …
4 replies
Hello, I would like to know if there is a better way to do the following: DECLARE @TempTab TABLE (P…
12 replies
Hello Everyone I am working with some odd data in the fact that someone placed two values in a sing…
5 replies
I'm trying to convert an Access query to SQL and I've run into a few problems. Here is the first, …
2 replies
0 down vote favorite I have a problem with my Merge statement (SCD type 1). I am getting the error:…
1 replies
Hi below is the scenario which I have currently in my query. I need to write this query without any…
1 replies
Following is my table definition CREATE TABLE dbo.Employee ( EmployeeIDINTNOT NULL, EmpFirst…
5 replies
Viewing 15 topics - 2,491 through 2,505 (of 10,647 total)
You must be logged in to create new topics.