T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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, 5 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, 5 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, 5 months ago

  By: WayneS

• Get data from a string

  Hi, I have a staging table e.g TRITON9700 L9700031288172 10-…

  PSB

  15 replies

  15 years, 5 months ago

  By: Lynn Pettis

• How to calculate open trade exposure?

  Hi, This is a bit of a long one, but quite interesting. I have the following (simplified) tables: I…

  keymoo

  1 replies

  15 years, 5 months ago

  By: LutzM

• Looping using CTE

  How can we do looping using CTE? Abhijit - http://abhijitmore.wordpress.com

  Abhijit More

  1 replies

  15 years, 5 months ago

  By: Grant Fritchey

• Get Date,Month from varchar dates

  I have dates stored as varchar(8) -- 113010 i.e mmddyy Timevarchar(6)--164018 I need to convert the…

  PSB

  7 replies

  15 years, 5 months ago

  By: PSB

• how to sync two tables columns?

  Hi Friends, Hope u are doing well. I am DBA but have very basic knowldge of T-SQL. My problem is as…

  MSQLDBA

  6 replies

  15 years, 5 months ago

  By: Grant Fritchey

• Is there a simipler way of filtering by current month

  If not I guess I can create my own udf. Thanks SELECT something FROM someentity WHERE DATEPART(MON…

  smallmoney

  4 replies

  15 years, 5 months ago

  By: Lynn Pettis

• Need help with a WHERE statement

  Here is my current SQL statement: SELECT a.request_id, a.req_type, a.status, b.event_type, b.p…

  davemcsheffrey

  10 replies

  15 years, 5 months ago

  By: david.watkins

• i need the location of the nth pipe in a given string. Must be dynamic. N will be input param eventually

  declare @position int declare @string varchar(2000) set @string = 'American Baby|BabyTalk|CTU|CordT…

  BaldingLoopMan

  1 replies

  15 years, 5 months ago

  By: GSquared

• multiple updates

  i have a 2 tables and i want the data from one table which has multiple data for a data to be updat…

  scottichrosaviakosmos

  4 replies

  15 years, 5 months ago

  By: LutzM

• Does the size of the model database increase automatically?

  When I first created instance of sql server 2008 , the model database primary data file was 1.75 MB…

  invaliddba

  15 replies

  15 years, 5 months ago

  By: Ivanna Noh

• variable in string

  Hi , i have blelow code and @command has string value and i want to assign Select @Dbnames = '+ @Db…

  sqlquery-101401

  7 replies

  15 years, 5 months ago

  By: sqlquery-101401

• String Concatenation from Update

  Hi, I am trying to update a table from another, but concatenate all the data from the secondary tab…

  Tom West

  5 replies

  15 years, 5 months ago

  By: ColdCoffee