T-SQL

• Topics

  Started by

  Posts

  Last post

• Getting the user name in another DB

  Hello everyone, What would be the better way to dynamically get the user name of my login in a data…

  Carl B.

  4 replies

  17 years, 12 months ago

  By: Carl B.

• Using INSERT INTO mixing SELECT and static text

  I'm trying to populate a table of pending emails. The problem is I need to populate the email fiel…

  brett spivey

  2 replies

  17 years, 12 months ago

  By: brett spivey

• Sql Error Number 141

  Hi. I have a T-SQL Query that give me the above Error. Here is the SQL Query. The name of the field…

  shayrosenfeld

  4 replies

  17 years, 12 months ago

  By: shayrosenfeld

• Deleting

  Hi All, If I have a delete query that would delete many thousands of rows, is there a was to cause …

  Philip Barry

  9 replies

  17 years, 12 months ago

  By: Jeff Moden

• How to Dynamically Updating Tables in the procedure...?

  Hi, I have a requirement to pass table name as parameter to a procedure and then based on that the …

  Ezhilan

  2 replies

  17 years, 12 months ago

  By: Sergiy

• Group By Issue

  Using SQL2K. I have the following query (copy and paste into Query Analyzer for proper formatting):…

  ryan.quigley

  7 replies

  17 years, 12 months ago

  By: ryan.quigley

• counting transactions

  I need help with some SQL query, may be really simple for some of you out there. I have a table wit…

  MikeJ-437562

  5 replies

  17 years, 12 months ago

  By: MikeJ-437562

• If Then logic

  In SQL Server 2000 queries, is there a way to replace results if a field happens to be empty? For e…

  Magy

  8 replies

  17 years, 12 months ago

  By: GSquared

• convert nvarchar(50) to datetime........Arithmetic overflow error

  Hello, I'm trying to convert nvarchar(50) field to datetime. For example, select convert(datetime, …

  Dom Horton

  1 replies

  17 years, 12 months ago

  By: Dom Horton

• Stored Procedure with a dynamic query

  I am looking for a way to optimize the following stored procedure in MSSQL 2000 Given a comma delim…

  Rebecca Rowland

  4 replies

  17 years, 12 months ago

  By: Rebecca Rowland

• using "AS" in a SQL statement

  Hello All, I have the following query select fname, lname, '1' AS Status from tblname when I run th…

  David-377753

  2 replies

  17 years, 12 months ago

  By: David-377753

• Delete dupes except for most recent

  I have two tables tblDupeIDs (EnrollmentID int, MaxUploadDate DateTime) tblEnrollment (EnrollmentID…

  Jonathan Matt

  2 replies

  17 years, 12 months ago

  By: Jonathan Matt

• Adding a datetime to an outgoing file from DTS

  I am trying to date a file in it's name everytime a DTS package runs. The package currently create…

  David Ladd-458242

  3 replies

  17 years, 12 months ago

  By: David Jackson

• Return Dynamic Sql results into a Table (How to)

  I think I know the 2-letter answer i might get on this one, but here goes .... (1) create a dynam…

  Sim-473257

  4 replies

  18 years ago

  By: Sergiy

• Reading IIS log files using DTS package

  Hi, I've created a DTS package for reading the IIS log file daily and ported into Tables. I used…

  balaji_rcs

  4 replies

  18 years ago

  By: izhar-azati