T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Getting Distinct Row identifiers for display

  I have a scenario in which the Primary name and the secondary names gets defined in columns for a S…

  JackIntheBox

  3 replies

  15 years, 5 months ago

  By: JackIntheBox

• A dirty question about XML

  I have some data in SQL Server I'd like to join with an XML document on the internet. The document …

  keymoo

  7 replies

  15 years, 5 months ago

  By: keymoo

• Better looping - replace for cursor

  Recently we replaced cursors with while loop and table variables. The block is something similar to…

  krishnaroopa

  20 replies

  15 years, 5 months ago

  By: dant12

• Help with Query

  I have a tracking DB filled with various data (id#, description, cost, Vdoc#, Idoc# and Cdoc#) All …

  aj_jm964

  10 replies

  15 years, 5 months ago

  By: Lynn Pettis

• Help with seemingly simple query

  Hi guys, I'm having a lot of trouble with this query so thought I would get some help here. I have …

  elogen

  4 replies

  15 years, 5 months ago

  By: Sachin Nandanwar

• Break Date Into Date Range

  I have a table that lists "Holidays": DECLARE @Holiday TABLE (HolidayId int identity(1,1) primary …

  BSavoie

  3 replies

  15 years, 5 months ago

  By: BSavoie

• There is insufficient system memory in resource pool 'internal' to run this query.

  Hello I get the above error while executing an .sql file that contains about 30mb of simple inserts…

  Dinculescu Mihai

  6 replies

  15 years, 5 months ago

  By: Koen Verbeeck

• Proc Performance

  I have a proc that has this Create proc myproc @param1 int = null, @param2 varchar = null, @param3 …

  Khades

  14 replies

  15 years, 5 months ago

  By: Jeff Moden

• Select column values as comma seperated format

  Hello, I need code that will select a single column from a table and put in into a variable in comm…

  David Kranes

  5 replies

  15 years, 5 months ago

  By: Jeff Moden

• Create stored procedure for parsing Comma Delimited string.

  Hello, I currently have a stored procedure written for Oracle that I need to port to SQL Server. B…

  David Kranes

  4 replies

  15 years, 5 months ago

  By: David Kranes

• Update with Row Lock -How to Optimize this

  I have a set of update statements with explicit row lock mentioned. On investigating I see that thi…

  facticatech

  6 replies

  15 years, 5 months ago

  By: dant12

• multiple join conditions and OR

  This is a theoretical question. I frequently use multiple join conditions separated by AND. Recentl…

  goofbauer

  4 replies

  15 years, 5 months ago

  By: goofbauer

• Issues with OpenXML under heavy load

  We uee BizTalk to call a stored procedure and insert records into a table. One of the parameters i…

  Mike01

  4 replies

  15 years, 5 months ago

  By: tertiusdp

• Future Forecast for performance

  Hello friends, How can we estimate how much time a particular sproc is supposed to take if the tabl…

  sql_butterfly

  9 replies

  15 years, 5 months ago

  By: TheSQLGuru

• Bulk Insert on SQL Server 2008 R2

  Hi , I recently came across with bulk insert , i need your help to resolve them. i have the followi…

  subbu_e

  7 replies

  15 years, 5 months ago

  By: subbu_e