T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Year to Today sales Figure

  Hi All, I need to calcualte the Year to Today sales details from last 4 years Is any simple sql sta…

  Mathew M.Varghese

  6 replies

  15 years, 7 months ago

  By: tfifield

• Update a date field to a specific day and time

  I have a temp table in which I want to update a date field. If the date field is after 07:00, I wan…

  Rog Saber

  3 replies

  15 years, 7 months ago

  By: Rog Saber

• Is it Poosible to Update the table with View one More table?

  Hi All. I have view with 3 tables inner joined, While I Bulk update with data , I have to Write thr…

  Saravanan_tvr

  2 replies

  15 years, 7 months ago

  By: movnabbs

• Problem with REPEATABLE READ

  Hello, I am having a problem with setting isolation level in the Stored Procedure. The following st…

  aptekman

  5 replies

  15 years, 7 months ago

  By: aptekman

• Query Performance

  Hi, Right now when we need to update values in a remote table in a Unidata database with values fro…

  Mike Scalise

  1 replies

  15 years, 7 months ago

  By: spaghettidba

• Most efficent way to merge data into SQL Server database from ODBC source

  I need to constantly merge (upsert/delete) data from an ODBC data source to a SQL Server 2008 datab…

  devora.fs

  3 replies

  15 years, 7 months ago

  By: devora.fs

• Maintennce Job step to shrink the transaction log on every db ~ dynamic SQL

  Hi One & All... Trying to get a create a nightly job to srink the transaction log for all dbs …

  Simon_L

  13 replies

  15 years, 7 months ago

  By: Pete-L

• Finding Sequences (Need help ASAP)

  Please skip to http://www.sqlservercentral.com/Forums/FindPost1000643.aspx for updated requirement…

  craig-404139

  91 replies

  15 years, 7 months ago

  By: Jeff Moden

• Merge error handling

  Need help handling errors while running a merge statement. How to I make the merge behave as if it…

  devora.fs

  2 replies

  15 years, 7 months ago

  By: devora.fs

• SQL Query Help

  I have attached result for the Query. Now my question is without this condition and b.Callback <…

  EasyBoy

  1 replies

  15 years, 7 months ago

  By: Ray K

• (TSQL) unique index on nvarchar(200) sparse null column

  0 down vote favorite Hi friends, I'm facing a confusing problem. If you create a table like the fol…

  ogrishman

  1 replies

  15 years, 7 months ago

  By: Gail Shaw

• create id's recursive

  Hi all, i have to generate id and parent_id with a recursive cte, first please execute this code: i…

  ralf.lulay

  2 replies

  15 years, 7 months ago

  By: ralf.lulay

• Special ORDER BY Case and can't figure it out

  Ok we have a printer that will print two 8.5 X 11 forms side by side, continuous. That said I need …

  Jeffery Williams

  8 replies

  15 years, 7 months ago

  By: rclarke 10167

• T-SQL Query

  Hi I'm new to t sql Please give me some idea on the following senario, There are 3 tables 1)table--…

  sql.pravin

  4 replies

  15 years, 8 months ago

  By: Grant Fritchey

• Replacing text within a single column, but not the entire string

  Hello Everyone I am working on trying to become better with some of the string functions in SQL. I …

  AndrewSQLDBA

  2 replies

  15 years, 8 months ago

  By: AndrewSQLDBA