T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• BULK INSERT

  I am using SQLServer 2005. I am trying to import a pipe delimited text file using BULK INSERT, my s…

  joefreeman

  2 replies

  16 years, 7 months ago

  By: joefreeman

• Error occurs while executing the stored procedure

  Sir, I am a begginner to SQL Server, when i execute my stored procedure i got the error like this…

  shameersinbox

  3 replies

  16 years, 7 months ago

  By: Steve Jones - SSC Editor

• grouping results for stats

  Hi Folks, I got some help on a report last week from Barry but now need to expand on that if possib…

  jb-1079038

  6 replies

  16 years, 7 months ago

  By: jb-1079038

• Bug in sys.dm_exec_sessions query

  I'm getting wierd results on the below given a query, if you agree perhaps one of you can report it…

  zach_john

  2 replies

  16 years, 7 months ago

  By: zach_john

• Convert XML Data to String / text

  Hi How to convert XML data field to string / text. Example: data is stored in the field is: T…

  Vijji-429978

  8 replies

  16 years, 7 months ago

  By: OTF

• Equivalent for SQL-Plus's "BREAK ON" in T-SQL

  Hello, I am trying to create a view which gives records. Some of them have the same values over mos…

  discover.sql

  3 replies

  16 years, 7 months ago

  By: OP_HELP

• Unable to sum correctly Error message

  SELECT distinct SD.ERP_ORDER, SH.SHIPMENT_ID, SH.INTERNAL_SHIPMENT_NUM, SC.ITEM, SC.LOT, SN.SERIAL…

  develope

  3 replies

  16 years, 7 months ago

  By: develope

• I got an answer of 4 for the above, was expecting that it would be 1.

  declare @table table (id int, [name] varchar(20)) insert into @table values(1,'SQL Server 2005') in…

  VM-723206

  12 replies

  16 years, 7 months ago

  By: VM-723206

• Create Multiple column Primary key on a table that already exists?

  Hello all. So I can go into the design mode of a table and ctrl + select columns to add them to a p…

  shannonjk

  4 replies

  16 years, 7 months ago

  By: GSquared

• can this UPDATE statement be optimized?

  I have an imported table with group names that are sharing a special code among rows. The business …

  Jesse Reich

  9 replies

  16 years, 7 months ago

  By: GSquared

• how to use a column name in argument of top() ?

  Hi, I have been receiving below error when i use top(p.nid) in my select. error: The reference to c…

  descentflower

  15 replies

  16 years, 7 months ago

  By: Dave Ballantyne

• Select from where problem

  Hi Guys, I'm stuck with a query that I could do with some help on if anybody doesn't mind: It goes …

  lemonsqueezy101

  7 replies

  16 years, 7 months ago

  By: Paul White

• Save SP Results to a TXT File

  Hi, I am using SQL 2005. I have a SP which creates temp tables from a selection of other tables. At…

  discreetfunct

  3 replies

  16 years, 7 months ago

  By: discreetfunct

• Shutdown instance, copy database files, and re-attach at destination server.

  Hi All, I have a requirement like, I am working with two servers,one is in intranet(lan or local…

  kishoretukuntla

  6 replies

  16 years, 7 months ago

  By: ps.

• Charindex and patindex

  Whats's the difference between charindex and patindex. blog: http://sarveshsingh.com Twitter: @sarv…

  ss-457805

  3 replies

  16 years, 7 months ago

  By: ps.