T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Sorting comma separated numbers

  Hello Friends, I am facing a tough challenge in sorting a string. My data is like…

  rockybhai

  19 replies

  14 years ago

  By: Jeff Moden

• Function to find whether last days of the month is weekend

  Hi, I am looking for a function to identify whether last day of the previous month is weekday or a …

  sandyschiru

  34 replies

  14 years ago

  By: Jeff Moden

• what is uniqueidentifier in sql how it will work

  Hi Friends, Any one can tell me what is uniqieidentifier ? where we use this? Thanks, Sandeep.

  sandeep4testing

  9 replies

  14 years ago

  By: Eugene Elutin

• Group adjacent records with repeating attributes

  Hi everyone, I have a problem with writing a query that will group data based on an attribute in on…

  mcc_petersson

  3 replies

  14 years ago

  By: mcc_petersson

• Removing alphabetic characters from a query result

  I've been racking my brain trying to figure this out, and can't seem to come up with a decent solut…

  Ray K

  5 replies

  14 years ago

  By: Lowell

• Using dynamic values

  I am using the following code to send an email to the customer, whenever the customer has an update…

  Achilies

  31 replies

  14 years ago

  By: Orlando Colamatteo

• HELP with a query

  I have a query that is really breaking my chops. I am joining three tables, PRD_Header, PRD_summary…

  ken def

  9 replies

  14 years ago

  By: drew.allen

• SSRS 2008 R2 - passing multi-value parameter to a subreport

  The report I have developed has a main report and four subreports. The main report receives three p…

  david.kratz

  6 replies

  14 years ago

  By: EdVassie

• SQL and binary numbers

  Im dealing with a our old mainframe that basically shoves everything into a sql database. i have a …

  JamesX

  22 replies

  14 years ago

  By: siva 20997

• Adding primarey key on table column

  Hi Friends, I'm trying to adding the primarey key on table column. table having 7 numbers of rows, …

  sandeep4testing

  8 replies

  14 years, 1 months ago

  By: Gail Shaw

• Can a select statement be used to parse the results of a stored procedure ?

  Hi all, If I exec an sp, I see my results table in the query analyser. But could I do this (or some…

  greg.bull

  1 replies

  14 years, 1 months ago

  By: LutzM

• How to update a column to the result of a Geocoding function

  I have a table of houses with addresses, which I eventually want to plot in a Report. I managed to…

  pietlinden

  5 replies

  14 years, 1 months ago

  By: pietlinden

• DATETIME data type subtraction

  I have a create_timestamp and modify_timestamp that are datetime data types. I need to find the dif…

  SQL_Enthusiast

  6 replies

  14 years, 1 months ago

  By: SQL_Enthusiast

• Having trouble tuning a large update query...looking for advice...

  I was asked to find out why a update is taking longer on a new (upgraded) server Old server (wind…

  Leeland

  19 replies

  14 years, 1 months ago

  By: Leeland

• To detect dead lock exists?

  Hello Friends, I am facing a challenge to develop an algorithm in T-SQL. Algorithm Logi…

  rockybhai

  13 replies

  14 years, 1 months ago

  By: Gail Shaw