General

• Topics

  Started by

  Posts

  Last post

• Convert RTF data

  Anyone know of a way to take rtf data (comes from a table field) and strip out the rtf garbage? we …

  QPR

  105 replies

  11 years ago

  By: bong03

• Exit code

  Hi, I am trying check if a files exists and if so continue with the procedure and if not exit out o…

  clucasi

  3 replies

  11 years ago

  By: Ed Wagner

• Are cursors hard on servers?

  I was reviewing a process with a colleague and mentioned cursors. He said, "Please don't use cursor…

  Rog Saber

  13 replies

  11 years ago

  By: Jeff Moden

• Adding Server Prefix to string of field names

  I am doing some dynamic programming and I have a list of field names that I am passing to a sql pro…

  GrassHopper

  1 replies

  11 years, 1 month ago

  By: GrassHopper

• .NET SSIS Script Task issue

  I am still a rookie when it comes to Visual Basic. I've been giving VB code to read a file into a F…

  Brandie Tarvin

  24 replies

  11 years, 1 month ago

  By: Brandie Tarvin

• Help with Syntax error

  Having some trouble with a syntax error related to the FROM statements on line 65 and 95: Use PARCS…

  mlwiller2

  3 replies

  11 years, 1 month ago

  By: Sean Lange

• No Value Given For One or More Required Parameter oledb to Excel

  In order to avoid the 255 character limitation in Excel and SSIS I have written a VB.Net SSIS scrip…

  chcampbelljr 84439

  7 replies

  11 years, 1 month ago

  By: chcampbelljr 84439

• Retrieve data from SQL stored procedure in MS Excel

  I have been searching this forum and the web to find the answer for this question, but no luck. I a…

  KC-219254

  47 replies

  11 years, 1 month ago

  By: stan.goodvibes

• SUSPECT DB

  HI WE HAVE TWO DATABASES AT OUR WORK PLACE. BOTH ARE SQL 2000. ONE OF THEM IS SHOWING SUSPECT IN SY…

  MANJUG05

  16 replies

  11 years, 2 months ago

  By: Gail Shaw

• Better way to write this query without calling a lookup for each column

  Hi All I have a query that needs to evaluate a set of columns (up to 350) and put either a value th…

  OlyKLin

  2 replies

  11 years, 2 months ago

  By: ChrisM@Work

• How do you do a GROUP BY on a value that's changed by a CASE?

  I've got a SELECT statement which I had hoped would give me what I needed, for counting the number …

  Rod at work

  4 replies

  11 years, 2 months ago

  By: Rod at work

• Running a SQL Job from .Net C# Windows Form

  Hello, I would like to have a button when pushed trigger a SQL Job run. Below is my code, for some…

  Meatloaf

  1 replies

  11 years, 3 months ago

  By: Meatloaf

• Mathematical Operation

  Hi, I need to write a stored proc that takes a set of input parameters and then performs mathematic…

  bikram.g.it

  3 replies

  11 years, 3 months ago

  By: Matt Miller (4)

• Convert IIF to Case Statements and Instr to charindex or Like

  I want to convert the ms access sql statement below to a Case statement in sql server TSQL. There …

  GrassHopper

  6 replies

  11 years, 3 months ago

  By: GrassHopper

• Patindex or Like

  I think I need a Patindex or Like in my TSQL to update a table, but I need a little help. I want to…

  GrassHopper

  6 replies

  11 years, 3 months ago

  By: GrassHopper