T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How to Merge dd,mm,yyyy hh,mm,ss(URGENT !!!)

  Hi Hi i have seperated dd,mm,yyy and hh,mm, ss. My Reqiuremet; I have data which is storing the "V…

  SPtrt

  2 replies

  15 years, 1 months ago

  By: Michael Valentine Jones

• Merge two rows with using date and time

  Hi, Help to give me an idea how to query to solve the below table Combine 1 and 1/2 an hour slot to…

  SPtrt

  8 replies

  15 years, 1 months ago

  By: GSquared

• Aggregate bit operator in TSQL

  Hello All: Do we have any aggregate bit operator in TSql? Consider the following scenario I have a …

  vishnu_modi

  28 replies

  15 years, 1 months ago

  By: Bob Schijvenaars

• Difference between IN and JOIN

  what is the exact difference between IN and JOIN? when to use IN and when to use JOIN...plz explain…

  deepikamm

  2 replies

  15 years, 1 months ago

  By: deepikamm

• Changing User defined data types

  Hi all... Created this user defined data type: CREATE TYPE [dbo].[address] FROM [char](30) NOT NU…

  mike 57299

  1 replies

  15 years, 1 months ago

  By: Ron McCullough

• Difference between AND & WHERE IN a QUERY ---- PLz reply

  Hi, What is the difference between the AND and WHERE Clause of a query. Fr ex - SELECT C.A …

  Rjch

  6 replies

  15 years, 1 months ago

  By: tfifield

• Insert several records into a table from one source table, without a cursor

  Is it possible to insert several rows into a table, based upon a source table and not involving a c…

  BrainDonor

  7 replies

  15 years, 1 months ago

  By: tfifield

• UTC Dates

  I've been having to deal with UTC dates quite heavily the last week. VERY humbling. I would like to…

  BSavoie

  2 replies

  15 years, 1 months ago

  By: BSavoie

• Long running update - looking to help speed it up

  First off, I didn't write this but did try to make it faster...I've tried looping through it snaggi…

  MyDoggieJessie

  8 replies

  15 years, 1 months ago

  By: tfifield

• Fiscal Year

  Hi all, i have this function which is not fully working. what it does is look at the date and work …

  jbon007

  6 replies

  15 years, 1 months ago

  By: Lynn Pettis

• DATEADD Function

  Hi, I have a date field named MyDate datatype datetime e.g =2010-06-23 00:00:00.000 in my query I …

  PSB

  3 replies

  15 years, 1 months ago

  By: PSB

• SQLCMD mode in Query Window using variables

  While the follwing example is possible :SETVAR DB_NAME_ASSIGN "TEST TEXT" :SETVAR DB_NAME_TEXT "EX…

  despag

  6 replies

  15 years, 1 months ago

  By: despag

• Index Challenge

  Hi Follks! I have one simple index related challage for all... CREATE TABLE TableX( X_ridint iden…

  Abhijit More

  7 replies

  15 years, 1 months ago

  By: Grant Fritchey

• Query Evaluation

  Hi, I have the following query. If you could help me to understand, how it will be evaluated, it wo…

  Pravasis S

  5 replies

  15 years, 1 months ago

  By: LutzM

• Separate Value from one Column to 4 different Column - May be Substring issue?

  Hi everyone, I have situation where i need to separate value from one column to four different col…

  keyun

  3 replies

  15 years, 1 months ago

  By: WayneS