T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Cursor killing my server

  I have a nightly job on my production database. This takes 30-40 minutes to execute. I looked into …

  chandan_jha18

  31 replies

  14 years, 10 months ago

  By: Spandan_buch 62172

• How to Replace XML with Table valued parameters?

  I have been asked to rewrite the code, which uses xml to send multiple rows to the backend ,with ta…

  deepikamm

  10 replies

  14 years, 10 months ago

  By: deepikamm

• Applying distinct on more than one field?

  Hi, I have a SQL query, like so: SELECT DISTINCT ID, Name FROM Table This brings up all the distinc…

  info-849042

  5 replies

  14 years, 10 months ago

  By: Cadavre

• Conditional Counting

  In UNICA.SUBS table i have Account, TRANS_DATE, TRANS_TYPE, PROD_CODE and CODE columns. SELECT…

  varunkum

  18 replies

  14 years, 10 months ago

  By: Jeff Moden

• Join a query to a table

  Hi, I can't seem to wrap my head around adding an additional column to this query. DECLARE @strVal…

  PHXHoward

  20 replies

  14 years, 10 months ago

  By: Jason-299789

• Is there any way to run the query more than 8000 character via openquery?

  Hi eneryone, Is there any way to run the query more than 8000 character via openquery? the query is…

  lindsaywang

  15 replies

  14 years, 10 months ago

  By: lindsaywang

• Need to import data into Sql Server Table from an excel File (using SQL commands)

  I need to import data into Sql Server Table from an excel File without using SSIS OR Import and exp…

  sandeep1188

  5 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• Using SQLCMD and redirecting the output not working

  I have 4 SQL's that I process using SQLCMD. I have the output redirecting to log files. Most of the…

  raterinkh

  3 replies

  14 years, 10 months ago

  By: vishal.gamji

• Clustered and Non Clustered

  Hi SQL guys, I still didnt got correct explanation for Clustered and Non Clustered. anyone? Thank y…

  Saranya20

  2 replies

  14 years, 10 months ago

  By: Gail Shaw

• how to query a table via its id

  Hello I just want to know how to query within a table by using its object_id for example Select * f…

  Navy Seal

  14 replies

  14 years, 10 months ago

  By: Navy Seal

• insert fails with violation of PK on table with identity column as PK

  Hello, I have the following scenario: A multi threaded application which is writing into a table th…

  Dan Puiu

  2 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• subquery concantenation with nulls

  Greetings - I think I may need "Coalesce" here but can't get my head around it. I have a query tha…

  Uripedes Pants

  2 replies

  14 years, 10 months ago

  By: Uripedes Pants

• Adding "Header" Information to the Beginning of the Root Node in XML

  I have the below query: SELECT top 1 listing as listing ,ISNULL(category,'…

  BoilerJ

  8 replies

  14 years, 10 months ago

  By: BoilerJ

• Proble with decimal division in a UDF

  Hi all: I am having trouble with some decimal division inside of UDF. For example, I want to get de…

  zhoujackji

  2 replies

  14 years, 10 months ago

  By: Lamprey13

• select case statement

  Have a table1 with following records Server name --------- …

  jaytaba

  4 replies

  14 years, 10 months ago

  By: jaytaba