T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Updating Multiiple value

  Suppose i have 2 table as Emp and Emp2. select empid from Emp where deptid=2 The output of the abov…

  Shadab Shah

  14 replies

  13 years, 8 months ago

  By: Leonard Rutkowski

• NULL, = NULL and IS NULL

  Hi N00b question perhaps, but I've just had to correct a SP which used x = NULL evaluations to use …

  derek.colley

  9 replies

  13 years, 8 months ago

  By: Gail Shaw

• Insert with sp_ExecuteSql

  Can anyone tell me why the script below is returning "Msg 102, Level 15, State 1, Line 1 Incorrect …

  mandoswork

  11 replies

  13 years, 8 months ago

  By: Luis Cazares

• Group by?

  So I am struggling to even get started on this issue. Basically I have a sales table laid out like …

  dave 92282

  5 replies

  13 years, 8 months ago

  By: Lynn Pettis

• need to know couple of things SET STATISTICS IO

  I have gone through technical documents.I am very much new to performance related queries I wrote c…

  Smash125

  2 replies

  13 years, 8 months ago

  By: HowardW

• Code behind IsNumeric() function

  Hi, Please let me know, how to see the coding part of IsNumeric() function in sql server. Regards, …

  Karthiart

  2 replies

  13 years, 8 months ago

  By: laurie-789651

• Inserting Month\Year based Records if they don't exist for the next 12 months

  Hi All, I'm using SQL Server 2008. I have the following problem which I could do with some help wit…

  Charlottecb

  20 replies

  13 years, 8 months ago

  By: Charlottecb

• Transaction taking forever to update rows on linked server

  I'm having some performance issues updating some rows on a linked server. The query is only updatin…

  joshd 1807

  3 replies

  13 years, 8 months ago

  By: Chrissy321

• Arranging column values in single row

  Hello All, I have situation where table(SQL server 2005) is like that, Orderid cost indic…

  roh_ranjan

  6 replies

  13 years, 8 months ago

  By: roh_ranjan

• stored procedure- error

  Hi, I have attached two files regarding execute SP at sql server 2008 databases,... It was working …

  SQL Galaxy

  4 replies

  13 years, 8 months ago

  By: Sean Lange

• Group By Help

  I have a script that uses the GROUP BY clause and returns the SUM much greater than expected. Here …

  JayWinter

  4 replies

  13 years, 8 months ago

  By: drew.allen

• Help assigning records from one table to another

  CREATE TABLE #MapIDs ( WonkyID CHAR(8) NOT NULL, Client VARCHAR(50) NULL, Identifier1 VARCHAR(12…

  jeffem

  7 replies

  13 years, 8 months ago

  By: Sean Lange

• repeatin value in my procedure

  Hi friends, I m write procedure for the problem is account trans date amount =================…

  raghuldrag

  12 replies

  13 years, 8 months ago

  By: gofrancesc

• Query throwing error when converting to Numeric

  Hi Experts, Please help me in this. I have a table where i am storing numeric value in Varchar colu…

  vijay.singh 14112

  5 replies

  13 years, 8 months ago

  By: ChrisM@Work

• Query help

  I have two tables with folowing sample data: tabA IdParentId 1001NULL 10021001 10031001 1004NU…

  sqlnaive

  12 replies

  13 years, 8 months ago

  By: SQL Padawan