T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months ago

  By: bpowers

• Blocking

  I have a procedure that gets called that at times seems to cause a block that last for avout 15 min…

  Rog Saber

  3 replies

  13 years, 10 months ago

  By: Rog Saber

• How can i select all dates between date range?

  I have one SQL Table with 2 columns as below Column1: ProductionDate - DateTime - Not NULL Column2:…

  rahulpatel112

  2 replies

  13 years, 10 months ago

  By: Steve Cullen

• Programmatically creating a table alias

  I was surprised to not find this in BOL, and am having a hard time finding this online, so I'm wond…

  Ray K

  10 replies

  13 years, 10 months ago

  By: Jeff Moden

• Read Windows Directory - error

  Hi all, I am trying to read a Windows Directory and then have SQL update a table with the informati…

  cleroux

  9 replies

  13 years, 10 months ago

  By: cleroux

• How to query results in debit and credit column

  Hi SQL Gurus, I would like to run a query to display the amount in a debit and credit column from a…

  yingchai

  8 replies

  13 years, 10 months ago

  By: ChrisM@Work

• Eliminating Duplicate Rows

  Hi, The output of my query contains duplicate records (i.e. column1 value is similar but other colu…

  prakashp 84206

  27 replies

  13 years, 10 months ago

  By: prakashp 84206

• How can I return value from function that comes from dynamic sql

  I need to get exchange rate from table. Parameters will be exchange type and date. return will be f…

  aykut canturk

  9 replies

  13 years, 10 months ago

  By: ChrisM@Work