T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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 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 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 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 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 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 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 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 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 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 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 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 ago

  By: AndrewSQLDBA

• Parent/Child relationship

  Any help would be appreciated. Classic parent/child relationship. Ideally I would want my flag fie…

  Chrissy321

  21 replies

  15 years ago

  By: Chrissy321

• Suppress output when changing configuration

  Hi, can I suppress the output of changing settings using T-SQL? How? Greets pitcher [font="Arial"]K…

  Patrick_Fiedler

  4 replies

  15 years ago

  By: Patrick_Fiedler

• Searching on Multiple Tables

  Hi, I know that many sql developer here can give me clarification on this matter. What I want to kn…

  Teemo

  1 replies

  15 years ago

  By: Jeff Moden