T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Field in SSRS report should be shown as (Days, Hours)

  Hi I have a requirement where a field in SSRS report should be shown as (Days, Hours) Ie. If it is …

  VSSGeorge

  1 replies

  14 years, 5 months ago

  By: Cadavre

• IF NOT EXISTS

  How do I get it NOT to error out if login already exists? IF NOT EXISTS(SELECT principal_id FROM s…

  SQLSeTTeR

  3 replies

  14 years, 5 months ago

  By: SQLSeTTeR

• invalid object name after creating table?

  Hi, In SQL 2K8, Table was created successfully, table was appear in database also select command wo…

  SQL Galaxy

  2 replies

  14 years, 5 months ago

  By: Paul White

• combining SP_who and SP_LOCK result sets

  How could I sort the result set of sp_lock by a specific count and then pass the spid of the lock i…

  kwoznica

  22 replies

  14 years, 5 months ago

  By: spaghettidba

• RE: How to add spaces to attribute based on the number of characters

  Hi I was wondering if someone could help me. Quick Background I have an attribute called ‘Vendor’ …

  Jnrstevej

  9 replies

  14 years, 5 months ago

  By: Jnrstevej

• Merge for Update,Delete,Insert

  Hi All I am new to merge statement so need your help in making it better understanding for my task.…

  sami.sqldba

  3 replies

  14 years, 5 months ago

  By: sami.sqldba

• identical on seperate servers, one is returning conversion errors. Why?

  I have a database restored on two seperate servers. The data in the database on each server is iden…

  winston Smith

  8 replies

  14 years, 5 months ago

  By: winston Smith

• Help with a Select statement

  Hi All, i have this data: declare @vartable TABLE( PAY_CYCLE varchar(50), PAY_CYCLE_SEQ_NUM INT, V…

  xRafo

  5 replies

  14 years, 5 months ago

  By: LutzM

• Table & Column Name (alias) dynamically using dynamic SQL

  Hi SQL Experts, I'm trying to automate a rather complicated process. The process compare numbers of…

  Welsh Corgi

  4 replies

  14 years, 5 months ago

  By: Welsh Corgi

• Looping through SELECT statement results to assign to variables

  Hello, Currently in the below stored procedure, I'm using a table variable to fetch results from th…

  anonymous2009

  2 replies

  14 years, 5 months ago

  By: spaghettidba

• DATETIME Query problem

  When developers are running cast on one of the systems the day and month are transposed. eg SELECT …

  Cookie SQL

  9 replies

  14 years, 5 months ago

  By: Jack Corbett

• Merge columns (large table)

  Hi, I am ok using MERGE I think its a great compromise on using separate commands but is there a wa…

  Essex

  13 replies

  14 years, 5 months ago

  By: Jason Selburg

• rows to columns

  I know this has been asked alot and I have read through a lot of articles on using pivots, row_numb…

  steve-760524

  7 replies

  14 years, 5 months ago

  By: steve-760524

• Could not find server '' in sys.servers.

  Hi All, i am trying to update some a table from another table in another database but am getting th…

  martin.kerr 34088

  4 replies

  14 years, 5 months ago

  By: azdzn

• Help on TSQL update statement

  Have a table data as below. UserID| ObjectID | Cid| Launch| startDate -----------…

  s-sql

  4 replies

  14 years, 5 months ago

  By: s-sql