T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Querying against a view or underlying tables: performance/reusability?

  Hello, I am new to writing optimized code; I tried to do this before but never had an application t…

  LisaGB

  8 replies

  14 years, 5 months ago

  By: Phil Parkin

• Advanced T-SQL Query

  Hi, I am practicing in Advanced T-Sql , i mean Nested Select statement. can anybody knows the resou…

  Jay Pete

  8 replies

  14 years, 5 months ago

  By: chris.stuart

• Execute Dynamically Generated Insert Statements

  I need to run various aggregations against multiple tables. There can be between 1-5 aggregations p…

  aaa121

  1 replies

  14 years, 5 months ago

  By: Nevyn

• XML Datatype

  Hi, I have a column where we are storing values in comma separated format. e.g. 1,2,3. These values…

  thbaig

  1 replies

  14 years, 5 months ago

  By: Orlando Colamatteo

• Totals and Grand Total working worng in SSAS

  Hi All, I have a scenario where i need to find the sales amount for yesterday and current day, and …

  naveenb.maram

  1 replies

  14 years, 5 months ago

  By: 1Ankit1

• How do i get my cursor to continue running after an error is raised

  Hi, I have set up and agent job which passes a list of databases on my sever into a cursor and then…

  DBANewbie

  14 replies

  14 years, 5 months ago

  By: DBANewbie

• SQL Grouping Data

  Hi, I am trying to get the invoice data from the invoice_head table(single row) with the invoice_li…

  ringovski

  31 replies

  14 years, 5 months ago

  By: ringovski

• Too much code for this T-SQL

  hi friends, I have got this code where it is looking for certain code in the table. It needs to loo…

  dva2007

  26 replies

  14 years, 5 months ago

  By: Ninja's_RGR'us

• No error for missing Linked Server?

  Scenario: Restored backup of database to new environment. Getting wonky results from external proc…

  Evil Kraig F

  3 replies

  14 years, 5 months ago

  By: Orlando Colamatteo

• sp_send_dbmail @query parameter

  I am trying to use sp_send_dbmail and execute a stored procedure for the @query parameter. I have t…

  ehlinger

  4 replies

  14 years, 5 months ago

  By: post.knowledge

• Executing a SQL View from Excel using VBA

  I have a need to get data out of SQL but it is a multiple table database with many JOINS tables to …

  brent.webster

  5 replies

  14 years, 5 months ago

  By: Phil Parkin

• Need error explanation for query, PLEASE

  Below are two similar queries. One works. One returns an error message that I need some explanatio…

  tonymartini777

  7 replies

  14 years, 5 months ago

  By: Sean Lange

• Delete Query and 'Transaction Log is full' Error

  We have this simple delete query: DELETE FROM Log_Hist WHERE (LogTime <= DATEADD(day, - 90, GETD…

  dso808

  10 replies

  14 years, 5 months ago

  By: dso808

• Speed up Index Creation time

  Hi all, Pretty broad question, but does anyone have any tips on how I can improve the speed of the …

  kramaswamy

  13 replies

  14 years, 5 months ago

  By: Gail Shaw

• String to Paragraph.

  Has anyone a procedure that will take a 150 character string and split it up into multiple smaller …

  Kelvin Phayre

  6 replies

  14 years, 5 months ago

  By: Kelvin Phayre