T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Compare two columns without Keys

  Hi, I did try a few google searches and was unable to find exactly what I am looking for because mo…

  hkflight

  5 replies

  15 years ago

  By: Ninja's_RGR'us

• Required: Good T-SQL query writer

  Hi, I need a reasonably complex query written against my database but I don't have the time or skil…

  keymoo

  1 replies

  15 years ago

  By: keymoo

• nodes and xml

  Msg 174, Level 15, State 1, Line 6 The nodes function requires 1 argument(s). I cant figure out was…

  kcbeard

  3 replies

  15 years ago

  By: kcbeard

• Group Records 1 to 1

  I am trying to extract data from a source table where groups of fields in one table can relate to o…

  eseosaoregie

  11 replies

  15 years ago

  By: eseosaoregie

• Unique sql request

  Hi experts, I have a very unique sql request here. I have 2 tables create table #Customer ( Custome…

  sqlislife

  11 replies

  15 years ago

  By: Ninja's_RGR'us

• I have a stored procedure that I need to pass a parameter into a case statement with IN in the the where

  I have a field in the where that’s an INT I tried the case below using 28,30 or 28 ‘,’30 I just can…

  Northern Monkey

  5 replies

  15 years ago

  By: Northern Monkey

• How to grant a role to a user

  I created a number of roles one of them being Principal. I want to grant this role to the user ravi…

  martin.s.ransome

  3 replies

  15 years ago

  By: martin.s.ransome

• SQL help

  Hi Guru, I need some help to query these two below tables: CREATE TABLE [dbo].[Transactions]( …

  Attopeu

  3 replies

  15 years ago

  By: Orlando Colamatteo

• Generate Table definition Script

  Hi All, I have 500+ tables in one database. Out of them I would like to script out about 230 tables…

  apat

  2 replies

  15 years ago

  By: apat

• TRIM

  Hey guys, I am importing a data file in SSIS and as I was doing the import I got an error message s…

  asm1212

  2 replies

  15 years ago

  By: Sean Lange

• Validating date range

  Dears, I have a table with following columns and test data for a particular employee : LeaveRequest…

  Ammar-349469

  5 replies

  15 years ago

  By: toddasd

• Numeric to time

  Hiya, I have a column with datatype numeric(19,4) which can have negative numbers. These are stored…

  lanky_doodle

  5 replies

  15 years ago

  By: spaghettidba

• populate 2 column results in a column

  Hi, I need your expertise on this issue. Basically the reason to do this is to group the rates so t…

  yingchai

  4 replies

  15 years ago

  By: Orlando Colamatteo

• Anyone can explain a question about TRANSACTION ISOLATION LEVEL ?!

  I have a query like this SET TRANSACTION ISOLATION LEVEL SERIALIZABLE WITH Customers AS ( SELECT * …

  zheng.xu

  3 replies

  15 years ago

  By: Grant Fritchey

• Need to show status change indicator

  Hi, I need to show the status change indicator in my sql.Its only for a club. Create Table Script d…

  kiran.rajenimbalkar

  5 replies

  15 years ago

  By: Sriram.RM