T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Rows to Columns

  Hi All, I have a requirement where the data in the table will be in this format. CREATE TABLE #T1(P…

  asashank82

  5 replies

  12 years ago

  By: asashank82

• So I got this .dbf file...

  And the date column is showing up like this in Excel: BDATE 380629 300517 670520 660402 470228 8604…

  sqldriver

  5 replies

  12 years ago

  By: sqldriver

• VB.NET TreeView using Stored Procedure

  There are 5 tables we have which has a parent child relation we have following tables. Order …

  skb 44459

  5 replies

  12 years ago

  By: skb 44459

• remove last character and reformat date

  Hi, I have a field (called 'perControl') that contains a date value, plus one character. But the va…

  krypto69

  11 replies

  12 years ago

  By: krypto69

• Finding Beginning of the week by specifying what day is the beginning of the week

  Function should let me select whats my beginning of the week is. If i select my beginning of week i…

  skb 44459

  1 replies

  12 years ago

  By: Lynn Pettis

• select top 1 value per group

  Hi , table structure (tblA): attribute varchar(20) State varchar(10) Sample data attribute : State …

  thbaig

  7 replies

  12 years ago

  By: thbaig

• OPENROWSET with spaces in sheet name

  Hi All, I'm trying to use the following statement to import data from an excel worksheet into sql, …

  jlperez19

  3 replies

  12 years ago

  By: Arthur Kirchner

• Could not create an acceptable cursor

  Hi, First time poster here, I'm having problems with an update statement at the moment, with an err…

  timothy.merridew

  25 replies

  12 years ago

  By: Sunny1

• syntax stumped

  Hi, Think I'm overlooking the obvious I have this statement: select *, '20' as [Yrs of Serv] from c…

  krypto69

  4 replies

  12 years ago

  By: krypto69

• Convert integer to 4-character alphnumeric representation

  I need to take a number (an integer identity column) and convert it to a 4 character representation…

  rburko

  13 replies

  12 years ago

  By: rburko

• SQL Table Variable Issue

  Good Afternoon All, I have defined a new Table Variable and initialized it. When I try to refera…

  paul.kuczwara

  11 replies

  12 years ago

  By: Jack Corbett

• I want to write validation Query which should return invalid parents I If any

  I have a table for which I want to validate where each parent intermediary is also a parent to itse…

  manoj.ramaiah

  1 replies

  12 years ago

  By: Bhaskar.Shetty

• OPENROWSET() Intermittently Fails to Read Excel File

  I've had this problem a number of times: every so often, I receive errors like this when trying to …

  Rich Mechaber

  5 replies

  12 years ago

  By: Rich Mechaber

• range and count of users

  I have a table which has 2 columns i.e. userid and points. I'm attemtping to get the number of user…

  rabisco

  6 replies

  12 years, 1 month ago

  By: rabisco

• Error converting datatypes ('NULL' to int and VARCHAR to int)

  Hello - my issue is that I need to get 5 rows of data from my PROD system down to my PROD-LIKE syst…

  SQL_ME_RICH

  7 replies

  12 years, 1 month ago

  By: SQL_ME_RICH