T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Unsupported datatype...Help!

  Hi there Hope someone can help me here please..... I have the following view which displays "Unsupp…

  Davebhoy

  3 replies

  11 years, 11 months ago

  By: ChrisM@Work

• ALTER DATABASE using CURSOR. Error: not a valid identifier

  Hi all, I'm really lost as to why i can't get this to work. I have an AlwaysOn AG with 42 databases…

  Bjarne Rasmussen

  2 replies

  11 years, 11 months ago

  By: Bjarne Rasmussen

• sp to move data between matching tables

  I find myself having to move specific portions of data from a final staging table to a live table o…

  sqldriver

  5 replies

  11 years, 11 months ago

  By: HanShi

• Pivoting the output of 8K “CSV Splitter” Function into destination table

  Hey All, I am using the Moden splitter (thanks!) to split a one column table containing a string in…

  Chrissy321

  4 replies

  11 years, 11 months ago

  By: Chrissy321

• Transaction log growing huge if DB is in simple recovery model

  Hi, I have one DB and that DB is growing if the DB is in simple recovery model. Please help me to r…

  santhosh411

  9 replies

  11 years, 11 months ago

  By: Jeff Moden

• Full Text Search Index Problem

  Select * from candidates WHERE contains(c_resume_text,'"c++" or "houston" or "New York" or "Amsterd…

  suresh0534

  1 replies

  11 years, 11 months ago

  By: Eugene Elutin

• how to write query to show in desired table fomat

  Hi, i have a requirement in sql server 2005 i have 2 tables as follows in both tables column "name"…

  suresh0534

  2 replies

  11 years, 11 months ago

  By: Eugene Elutin

• Need some eyes on a SP I'm working on

  Hi, The point of this is to check for a file on a remote folder, move it to the processing folder, …

  sqldriver

  21 replies

  11 years, 11 months ago

  By: sqldriver

• script errors

  Hi, I am getting an error msg while executing a script file like " script executed with errors" but…

  pmadhavapeddi22

  6 replies

  11 years, 11 months ago

  By: Phil Parkin

• Update command set data has apostrophe in it

  update [db.table] set [field]= '[BOB SAID:] "data" I want in table has multiple ' apostrophes ' in …

  lawson2305

  2 replies

  11 years, 11 months ago

  By: Sean Lange

• Count technicians passing on a call

  Here is the table creation script and some sample data (apologies for the varchar date, it's what I…

  DixieDean

  3 replies

  11 years, 11 months ago

  By: DixieDean

• Create procedure for data modification

  table name : mrinf fields : companycode nchar(4), mrno (nchar(9), chqno nvarchar (50), tranamount d…

  Neel 7777

  9 replies

  11 years, 11 months ago

  By: Neel 7777

• need help with using data in a certain way

  Hello, I seem to be having a problem arranging my data in a way that can be utilized by a specific …

  slatinsky

  8 replies

  11 years, 11 months ago

  By: slatinsky

• More help wit Sum, Pivot and so on...

  Hi! First thanks for the help I got a couple of weeks ago! Now to my new proble that is to change…

  tota00

  10 replies

  11 years, 11 months ago

  By: MMartin1

• Error converting data type varchar to numeric in CASE statement

  Sorry for the narrative but I can't seem to generate sample data to reproduce my problem... I have …

  Chrissy321

  13 replies

  11 years, 11 months ago

  By: Jason Wolfkill