T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• PIVOT-ing solution needed for diary viewer

  Hi all, I have a table that stores "register" information, e.g. UserID, RegisterDate, Available/Una…

  kevinp81

  2 replies

  12 years, 10 months ago

  By: kevinp81

• How to add column and then sum

  I have this same statement, can't seem to figure this out. How can I SUM the 'current amount' colu…

  krypto69

  2 replies

  12 years, 10 months ago

  By: Luis Cazares

• same variable in stored proc

  hi in my stored proc i have 3-4 while loop and i need to use different variable for it i m having m…

  riya_dave

  5 replies

  12 years, 10 months ago

  By: Alexander Suprun

• Looking for a clever solution

  Hi everyone, We have a SP that is quite long and it has a lot of such code: UPDATE table1 SET co…

  shahgols

  5 replies

  12 years, 10 months ago

  By: Chrissy321

• where filter col <> 0 returns error, col > 0 works, col contains no 0

  Hi, I can't explain the following behaviour: I join 2 tables and depending on the where filter I ge…

  Ralf

  7 replies

  12 years, 10 months ago

  By: Ralf

• Invalid column name?

  I have this query works great - no problem: select * from (SELECT pehPErcontrol,case left(substrin…

  krypto69

  3 replies

  12 years, 10 months ago

  By: ChrisM@Work

• Index and Table Size

  Hello Everyone Happy hump day to all. I am working on gather some stats for each table in a databas…

  AndrewSQLDBA

  5 replies

  12 years, 10 months ago

  By: Perry Whittle

• Read a table within a table

  I have a table with articles and a view with additional article information. For an article in the …

  bdeboer

  1 replies

  12 years, 10 months ago

  By: Koen Verbeeck

• Help needed in writing a stored procedure

  I have a table create table searchtbl ( skills varchar(100), position varchar(40), location varchar…

  iiit.raju

  10 replies

  12 years, 10 months ago

  By: HanShi

• SPs inside BEGIN/ROLLBACK TRAN

  When testing Stored Procedures, can you run something like BEGIN TRAN EXEC sp_deleteSomeRecords "V…

  dan-572483

  11 replies

  12 years, 10 months ago

  By: kapil_kk

• Error inserting data with T-sql

  Hello I am inserting data from one table to another using update,set command and getting the follow…

  jdbrown239

  8 replies

  12 years, 10 months ago

  By: Eric M Russell

• Can I join on an alias?

  Is it possible to create a join on an alias? I have this query that I need to join to a table (mont…

  krypto69

  5 replies

  12 years, 10 months ago

  By: krypto69

• SP Date parameter default to GETDATE()?

  I want my procedure to include an optional date parameter that defaults to the current date. Why do…

  dan-572483

  10 replies

  12 years, 10 months ago

  By: Michael Valentine Jones

• How to Parse two string Columns using a Function

  I need to parse the sample data below as shown. Please help me in writing a TSQL Function. Create …

  onlygoodones

  6 replies

  12 years, 10 months ago

  By: onlygoodones

• Need help with Select Where clause using parameter equal blank or in a list

  I have a stored procedure that passes in several parameters that can be blank or a list of selected…

  jplankenhorn

  8 replies

  12 years, 10 months ago

  By: Sean Lange