T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Print (5596 / 11784) --- > yields 0 (should return .47 and not 0)

  Removed by GaMusicMan

  GaMusicMan

  6 replies

  15 years ago

  By: ColdCoffee

• Export to Flat File issues plz help me on with it...

  I am trying to export a table to flat file using Pipe Delimited(Doesnt matter if its other delimite…

  Chinna

  4 replies

  15 years ago

  By: Chinna

• simple case vs. searched case

  Hi, Does it matter if I use simple case, i.e. SELECT CASE STATUS WHEN 'A' THEN 1 WHEN 'B' THEN 2 E…

  btio_3000

  4 replies

  15 years ago

  By: btio_3000

• Need to match a number in SQL

  I have a field that can contain different types of info, I want to match a 10-digit number. How can…

  Noc234234

  2 replies

  15 years ago

  By: Orlando Colamatteo

• Difference between temp table, table variable, derived table and CTE

  Hi, Please let me know difference between temp table, table variable, derived table and CTE. Thanks…

  durga palepu

  3 replies

  15 years ago

  By: Jeff Moden

• How to Add Column Header

  I receive semi colon delimited txt file and the column placements/position are always same. Current…

  JStevenson1

  4 replies

  15 years ago

  By: Phil Parkin

• How to find the SQL Server's FQDN using t-sql and insert into a field in a record

  I am trying to find my SQL Server's FQDN using T-SQL and then have it inserted into all of the fiel…

  Makers_Mark

  10 replies

  15 years ago

  By: iDiPs

• Need help with finding min and max date within a range

  I'd like to have the min and max date for each dept, but so far I've been stumped when the person g…

  Scott Carter-357760

  3 replies

  15 years ago

  By: Evil Kraig F

• Need help in TSQL logic

  I have two tables. TableA and TableB and both contains 3 columns. The amount which is entered in t…

  sam-1083699

  1 replies

  15 years ago

  By: Orlando Colamatteo

• Find previous date in a series

  We have a fairly standard table, A Customer table. PK is Customer_ID and End_Effective_Date. One o…

  stevet 20325

  6 replies

  15 years ago

  By: TheSQLGuru

• NULL Dates

  Is there a way to replace NULL to a datetime column instead of 1900-01-01 00:00:00.000 for NULL dat…

  LOOKUP_BI-756009

  10 replies

  15 years ago

  By: Jeff Moden

• How to lock a table without a transaction

  I have "running total" that I solved using..... cursors. Anyway, very slow, about 5 minutes. I don'…

  bcronce

  3 replies

  15 years ago

  By: Evil Kraig F

• TSQL Logic help needed-- Nested IF

  I am working on implementing a business logic, I need help figuring out the logic Logic: Each cust…

  Minnesota - Viking

  19 replies

  15 years ago

  By: WayneS

• maybe need a plan guide?

  Gotta question about a possible plan guide scenario. I have a sproc that executes a sequence of sta…

  sqlpadawan_1

  3 replies

  15 years ago

  By: TheSQLGuru

• recovery model bulk-logged gives big log file

  Hello, I have an development database which I need to refill with production data on a regular basi…

  BenniePielaat

  4 replies

  15 years ago

  By: Michael L John