T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Convert Varchar to Decimal

  Hi, Select LHP.LHP_PARAM_RESULT_VALUE, Cast(Replace(LHP.LHP_PARAM_RESULT_VALUE,',','') as decimal(1…

  raguyazhin

  14 replies

  12 years, 1 month ago

  By: MMartin1

• Date Conversion Fails in Stored Procedure - But code works in a Trigger !?

  Hi All, I have a Trigger which basically using the INSERTED and DELETED Tables - populates an "Audi…

  SteveEClarke

  8 replies

  12 years, 1 month ago

  By: Phil Parkin

• SUM CASE, COLUMN MINUS COLUMN

  I have this code working fine. I need to subtract one column from another to get the corrected resu…

  kabaari

  12 replies

  12 years, 1 month ago

  By: Jason Wolfkill

• Error converting string to date

  Hi, I've got a really annoying problem in that I have a char column (loaded from csv) that contains…

  BenWard

  7 replies

  12 years, 1 month ago

  By: Steven Willis

• Droping out of a cusor

  Hi what’s the best to way to drop out of a cursor if a condition is meet? Many thanks

  Edward-445599

  4 replies

  12 years, 1 month ago

  By: TheSQLGuru

• Help with sql statement to delete old records for user if multiple records found

  Here is how the data looks like for UserSession Table UserName LastUpdated sessionID -----…

  skb 44459

  6 replies

  12 years, 1 month ago

  By: Jeff Moden

• cannot insert duplicate key row in object 'tablename' with unique index 'indexname'

  Hi, I have an MS Access application whose tables are linked via ODBC connection to SQL server 2005.…

  VRT

  14 replies

  12 years, 1 month ago

  By: Jason Wolfkill

• SQL Report formatting with UNION Clause

  I have an sql like this: SELECT 1 AS GROUPID, 'A' AS GROUPNAME, ''GROUPID, ''GROUPNAME UNION SELECT…

  Boby B Jacob

  3 replies

  12 years, 1 month ago

  By: Boby B Jacob

• Update table using Group By

  Hi, I have a column (Total) which needs to be updated based on a calculation of 2 other columns(Ass…

  DerbyNeal

  2 replies

  12 years, 1 month ago

  By: geoff5

• DBCC Shrinkfile issues

  First of all, I know I shouldn't do a shrink file because it causes fragmentation. however, I am w…

  Laura Schmalzbauer

  4 replies

  12 years, 1 month ago

  By: Gail Shaw

• column update based on calculation and group by

  Hi, I need to update the Perc column in Table_A This is based on the following calculation: ((Pass/…

  DerbyNeal

  7 replies

  12 years, 2 months ago

  By: DerbyNeal

• Convert varchar back into datetime??

  Hello - I have a column in my View script that I convert to varchar(10) and want to convert it bac…

  david.ostrander

  3 replies

  12 years, 2 months ago

  By: Lynn Pettis

• Email validation question

  Hi, A stored procedure calls on this UDF. I have to update it to exclude email addresses with '.@' …

  sqldriver

  8 replies

  12 years, 2 months ago

  By: Orlando Colamatteo

• XML Parsing - Unable to switch the encoding - SQL Parameter

  I pass an XML parameter from a C# program. This seems to work fine if i change the encoding from ut…

  TcW_1978

  1 replies

  12 years, 2 months ago

  By: TcW_1978

• Get count while insert is still running

  I'm running something like this: more: waitfor delay '00:00:05' insert top (1000) into TableB Selec…

  homebrew01

  11 replies

  12 years, 2 months ago

  By: homebrew01