T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Select Number before "/"

  Hi All, I am new to SQL, Can anyone help me with the Substring/ or other function to select only th…

  munnug123 21921

  6 replies

  14 years ago

  By: Dwain Camps

• Bad Excution plan vs Good execution plan

  I'm attaching two execution plans. I is bad plan and second is bad plan. Both are coming from same …

  sqlnaive

  5 replies

  14 years ago

  By: Grant Fritchey

• Select a chain

  Hi I have a table with 2 ids in it here is an example ID FromID 1 0 2 1 3 0 4 2 5 …

  erics44

  7 replies

  14 years ago

  By: erics44

• XML .modify "where" clause problem

  Hi Looking to update xml field where I will have multiple occurrences of the same node name at vari…

  Simon Brown-346003

  2 replies

  14 years ago

  By: Simon Brown-346003

• Sum the most recent record for each day

  Hi All, I have a revision process where newer records supercede older records but the older records…

  Chrissy321

  10 replies

  14 years ago

  By: Chrissy321

• Adding values for the extended properties if not present

  Hello All, I am newbie to sql server programming. I have a script that will add the extended proper…

  SQL Prog

  6 replies

  14 years ago

  By: SQL Prog

• Is there some bug?

  I have a job,Occurs every day at 5:00:00, and my databases(total 5 database in the server) size is…

  cs_lb

  4 replies

  14 years ago

  By: Thomas Stringer

• Can you use full text contains to match two similar fields in two seperate tables?

  Hi All- I have two tables, each with a full text index on the provider_name field. I have searched …

  paulgill

  2 replies

  14 years ago

  By: Eugene Elutin

• Tsql help on Passing values as parameters

  Hi all, Below is the data in the temp table and I have to pass 4 parameters and 4 values to get the…

  etirem

  11 replies

  14 years ago

  By: Dwain Camps

• setting default user in sql server 2008

  I want t-sql statement for setting default user at the time of creating database in sql server.

  sej2008

  4 replies

  14 years ago

  By: SpringTownDBA

• Concatenate Rows

  Hi, I am looking for a higher performance way to take the text of a series of rows, concatenate it,…

  David Lester

  3 replies

  14 years ago

  By: Lynn Pettis

• error connection to remote server

  hi i want to connect to sql server from local, getting this error: A network-related or instance-sp…

  harri.reddy

  10 replies

  14 years ago

  By: harri.reddy

• Data loading through t-script from stage to dev or qa or prod.

  Hi, following is the code snippet to load data from stage to target in dev/qa/prod environments. bo…

  dsh_roy

  3 replies

  14 years ago

  By: dsh_roy

• Msg 102, Level 15, State 1, Incorrect syntax near '.'; Msg 156, level 15 State1 Incorrect syntax near the keyword 'AS'

  Please help me to find the error when I use merge it work but when I add the insert into statement …

  annkimle

  3 replies

  14 years ago

  By: annkimle

• Trim String

  How would I go about trimming the followin string, so that I only see the "File"? Everything after …

  bpowers

  5 replies

  14 years ago

  By: bpowers