T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Get Totals From Combined Rows

  Hello I have a data structure like this: Entities 1 - X EntitieDefinition 1 - X Data I have a query…

  rootfixxxer

  3 replies

  14 years ago

  By: Eugene Elutin

• Using sp_ExecuteSQL

  Hello, If I create some dynamic SQL and execute it using sp_ExecuteSQL, and the SQL I created gener…

  Mr. Cursor

  3 replies

  14 years ago

  By: Mr. Cursor

• Using IF EXISTS & NOT EXISTS DROP Primary Key Constraint

  I was trying to add code to Drop the PK, if it exists and after a Load, I want to Create the PK if …

  Welsh Corgi

  8 replies

  14 years ago

  By: Eugene Elutin

• "Divide by zero error encountered." in where clause on SQL 2008 and working OK on SQL 2000

  This query was working on SQL 2000 but on SQL 2008 is giving me the error "Divide by zero error enc…

  logavina

  5 replies

  14 years ago

  By: Eugene Elutin

• Need a T-SQL Script to create millions of rows

  Hi all, Can anyone provide a customizable T-SQL script to create millions of rows in a table? My un…

  beginnew2012

  23 replies

  14 years ago

  By: beginnew2012

• Recursion - find last child

  Never done recursion in MS SQL. Looked at few samples using CTE, but haven't found what I am lookin…

  dmayley

  13 replies

  14 years ago

  By: Jeff Moden

• Values into separate columns

  Hi all, I have a table that looks like this. CREATE TABLE #tmp1 (PartID VARCHAR(8), CodeA VARCHAR(…

  Mr. Holio

  6 replies

  14 years ago

  By: spaghettidba

• Query help urgent!!

  Hi i m newbie for this forum. I have query and it has parameter dates If i change date from 2/1/200…

  pantherUSA

  9 replies

  14 years ago

  By: OTF

• Need ideas on query performance

  I have 2 tables (suppose A and B) with around 1 million rows each. I want to find and delete the re…

  mayurkb

  20 replies

  14 years ago

  By: Eugene Elutin

• Query Performance

  Dear all; Table having 1 million record we have to write the quries like this . the number of union…

  sqlfriends@sql.com

  3 replies

  14 years ago

  By: Vedran Kesegic

• Long running query on only one server

  I have a query that ran in 3 seconds on a 2008 server, then we moved the database and everything to…

  ImYourDBA

  14 replies

  14 years ago

  By: ImYourDBA

• Need Year & the Month of a Date Field Formated as 'YYYYMM'

  I need the Year & the Month of a Date Field Formatted as 'YYYYMM'. Any help would be greatly a…

  Welsh Corgi

  18 replies

  14 years ago

  By: Welsh Corgi

• Query Help

  Looking for help on the following query. Create table tmpUserDetails ( Userid int, LocationIDint, …

  s-sql

  12 replies

  14 years ago

  By: s-sql

• Swapping rows on a condition

  Hi all. I have a table that contains values for time planning. It is self-referencing, so that the…

  greg.bull

  12 replies

  14 years ago

  By: greg.bull

• Reading data from two CSV files

  Hi I had two CSV parameter, i want to read this CSV parameter and insert into a table Declare @Adu…

  SQL006

  3 replies

  14 years ago

  By: SQL006