T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• varchar to nvarchar

  hi, while changing the varchar to nvarchar on my tables to support unicode, do i have to increase t…

  Anamika

  14 replies

  13 years, 3 months ago

  By: Eugene Elutin

• List first one in each group

  I'm having a brain dead day. I used to know how to do this. I have several thousand providers in a…

  CAGreensfelder

  2 replies

  13 years, 3 months ago

  By: CAGreensfelder

• Formatting for SSRS

  Hi guys, the below query works fine until I try to put it into SSRS when it complains that I have a…

  shutts318ci

  1 replies

  13 years, 3 months ago

  By: shutts318ci

• What sites didn't report on what days?

  Hello. Given a list of SiteId/date combinations and a date tally table I'm trying to figure out wha…

  ken.trock

  2 replies

  13 years, 3 months ago

  By: ken.trock

• Please help on Logic

  Hi, I need help on data level error handling. I have csv file with Data like First row is column he…

  Ram:)

  22 replies

  13 years, 3 months ago

  By: J Livingston SQL

• if exists condition

  I have 2 database exmp: db1 and db2 I have a procedure named proc1 which is already present in db1 …

  scottichrosaviakosmos

  12 replies

  13 years, 3 months ago

  By: scottichrosaviakosmos

• public Function

  is it possible to create a function which is available for all Databases(i.e) when i create a proce…

  thava

  3 replies

  13 years, 3 months ago

  By: Jeff Moden

• Update issue on table join

  Hi, We have two similar files, one header file and one line file. Under certain conditions*, the li…

  DerbyNeal

  3 replies

  13 years, 3 months ago

  By: spaghettidba

• Get Time defaulters list

  Following are the table details 1. name: time_tbl columns: time_id employee_id time_date (date) tim…

  srimat

  2 replies

  13 years, 3 months ago

  By: srimat

• Need Query Help

  Hi, I have table Student with these columns names student_code , stud_act_id , fee , discount_…

  suresh0534

  1 replies

  13 years, 3 months ago

  By: Possinator

• using AFTER UPDATE trigger to insert into a second table

  Hi, I have two SQL tables which are referenced within a trigger. I have tested the trigger in a 'de…

  DerbyNeal

  5 replies

  13 years, 3 months ago

  By: DerbyNeal

• Need help with writing to text file, new to sql server

  Hi Guys I am new to sql server and require a procedure which is able to output data to a text file …

  ram_kamboz2k7

  22 replies

  13 years, 3 months ago

  By: John Mitchell-245523

• Please help with this query. This is very challenging.

  I have the following data in my single table. create table dbo.test_table (part varchar(5), stat va…

  dcw8888

  3 replies

  13 years, 3 months ago

  By: Jeff Moden

• how to remove trailing zeros from zip codes

  I have a column that holds zip codes I need to remove 4 trailing zeros how can I do this? the zip c…

  sbarlow

  6 replies

  13 years, 4 months ago

  By: sbarlow

• Is it possible to configure a Linked server in SQL Client?

  I am trying to export data into Excel file using OPENROWSET. USE [AdventureWorks]; GO INSERT INTO O…

  sharma-691993

  6 replies

  13 years, 4 months ago

  By: Phil Parkin