T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• query help.. pls

  Hi, I have data as follows sno id product 1 1000 'aaaaa' 2 1001 'bbbbb' 3 1000 'tttttt' 5 1000 'ddd…

  Ram:)

  2 replies

  15 years, 5 months ago

  By: Ron McCullough

• MERGING TABLES - SQL QUERY .. HELP PLS

  Hi, Can any one help me on this.. Here I have 2 tables, call it as parent table, child table.. I wa…

  Ram:)

  2 replies

  15 years, 5 months ago

  By: Ram:)

• filter out expired records

  I have a table that has these columns, clientnumber, code, plan, and eff_date, and more. Some reco…

  rightfield

  3 replies

  15 years, 5 months ago

  By: RP_DBA

• Check For Data and Convert

  Hi, This is a a follow up question (but different issue), to my previous post on http://www.sqlserv…

  EjSQLme

  4 replies

  15 years, 5 months ago

  By: EjSQLme

• Full Text Error log

  Hi I have one question regarding full text . I have created one full text catalog and added 5 table…

  rajmaiet

  2 replies

  15 years, 5 months ago

  By: rajmaiet

• I need to pull one recod per load_id I need the min(A.TMS_EXT_REF_ID ) city,state but

  I need to pull one recod per load_id I need the min(A.TMS_EXT_REF_ID ) city,state etc.. information…

  twdavis-893252

  9 replies

  15 years, 5 months ago

  By: Mike01

• Select into with a loop

  Please help me to write a query. This is the task. I have Table a and B. Table B has millions of ro…

  TonyK_Ga

  6 replies

  15 years, 5 months ago

  By: Ben Teraberry

• Bulk insert issue...pls help

  Hi, I have a bulk insert statement that is loading a text file into a table. It is working fine whe…

  ek-822869

  1 replies

  15 years, 5 months ago

  By: ek-822869

• Fixed length columns

  Can any body help on this http://www.sqlservercentral.com/Forums/Topic955901-8-1.aspx 🙂

  Ram:)

  8 replies

  15 years, 5 months ago

  By: Ram:)

• Nest child elements using for xml

  Hi all, I'm having trouble trying trying to write an sql for xml query that will create a nested hi…

  philbags

  2 replies

  15 years, 5 months ago

  By: philbags

• “Distinct” column in SQL query results

  I have the following data COL1 COL2 1 0TY/OK 1 0TY/OK 1 0TY/OK 1 0TY/O…

  Nickson Asiimwe

  9 replies

  15 years, 5 months ago

  By: Jeff Moden

• Help with bulk random code insert

  Hi I need to select some records and reinsert/duplicate them again (not replace them) with a set of…

  david meagor

  10 replies

  15 years, 5 months ago

  By: Eugene Elutin

• help with QUOTED_IDENTIFIER

  hi guys, i have my dev and production instances in two different servers with the same database wit…

  DBA-640728

  9 replies

  15 years, 5 months ago

  By: DBA-640728

• If...Else condition in store procedure to set value in variable

  hi,i want to select my data from table using where clause.then i want to use if else condition to s…

  anamika.singh282

  9 replies

  15 years, 5 months ago

  By: Arjun Sivadasan

• Need help to produce SQL

  I've table and data as follow, declare @t1 table (idx int, maintdte datetime); insert into @t1 valu…

  miss.delinda

  3 replies

  15 years, 5 months ago

  By: Praveen Goud Kotha