T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• inserting value into identity column

  Hi, I have a table with identity column and i have data in identity column from 1 to 10 and 20 …

  vaithi.saran846

  3 replies

  13 years, 6 months ago

  By: Johan Bijnens

• "fetch"

  How to fetch the records when salary flag equal to 1 then sum up the corresponding vacation hours a…

  aanryn

  3 replies

  13 years, 6 months ago

  By: Tushar.Tupe

• Windows update may have broken sp_OAGetProperty and TotalSize

  Hi, We use the script below (modified version of a standard script found via Google) to gather tota…

  jasonmorris

  2 replies

  13 years, 6 months ago

  By: jasonmorris

• Can we remove temp tables to improve performance

  Hello guys, Please give some inputs for an newbie. The plan is to redevelop 10 PL/SQL package hundr…

  andyron

  9 replies

  13 years, 7 months ago

  By: andyron

• Not sure if this is possible..

  I have a file that gets imported every morning. This file is named every day with the date. For ex…

  krypto69

  2 replies

  13 years, 7 months ago

  By: fitsumkh

• Query xml column

  I am new to xml and have been banging my head against the wall on this one. It's probably somethin…

  brendan woulfe

  6 replies

  13 years, 7 months ago

  By: brendan woulfe

• Get Hard Disk information from linked servers

  Hi There, As a MS SQL Server 2005 DBA where I have to maintain 10 production SQL Servers 2005 I hav…

  mvdveer

  4 replies

  13 years, 7 months ago

  By: jasonmorris

• Filling Data Gaps for YTD Totals

  I've found many posts on this topic, but haven't quite found a solution. I'd rather handle this in…

  r3volver

  1 replies

  13 years, 7 months ago

  By: Evil Kraig F

• Issue with multi selection option in dropdown list

  Hi, I have a procedure with two input parameters @bank and another one is @productid,for these …

  atlancharlo

  3 replies

  13 years, 7 months ago

  By: drew.allen

• Incorrect syntax near 'GO'

  Why do I keep getting Incorrect syntax near 'GO'? DECLARE @dbname varchar(255) DECLARE @sql nvarch…

  LOOKUP_BI-756009

  9 replies

  13 years, 7 months ago

  By: Gail Shaw

• Function + Performance

  Hi All, I have seen a UPDATE statement as below in my database. update factor set net_return = fn_c…

  karthik M

  5 replies

  13 years, 7 months ago

  By: spaghettidba

• Maximum flow from continuous flow rate

  I'm having trouble with this one, and haven't found ideas on the web. Given a day's worth of nearly…

  Brian Ki

  23 replies

  13 years, 7 months ago

  By: Evil Kraig F

• create a function for multi selection option in drop down list

  Hi, I want a code for how to create a seperate function outside,i have a parameter in my pr…

  atlancharlo

  1 replies

  13 years, 7 months ago

  By: Sean Lange

• Error converting data type varchar to numeric- sql 2005

  I have a column which is varchar datatype but has data as 2.5, 10.8 and so forth. when i check if t…

  ishaan99

  7 replies

  13 years, 7 months ago

  By: j.miner

• Best Approach to remove data within a table

  Hello Lets say i have a table (table1) which has a number of account numbers for customers. Now th…

  8-Bit Ninja

  2 replies

  13 years, 7 months ago

  By: 8-Bit Ninja