T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Need to consolidate data from Multiple EXECs

  I need to pull data using multiple EXECs to get individual items. Example: EXEC Rpt_ItemWhereUsedS…

  ducksql@gmail.com

  11 replies

  13 years, 6 months ago

  By: BenWard

• create table from USP output - How to do it?

  Is there a way to make the following thing happen in SQL: @STR = 'USP parm1, parm2' select * into B…

  Tobar

  3 replies

  13 years, 6 months ago

  By: Tobar

• CONVERT(varchar(@MAXLENGTH),x) FROM y

  Not sure how to google for this ... proc outputs to text file. for formatting reasons only I want t…

  snomadj

  5 replies

  13 years, 6 months ago

  By: snomadj

• RANK / PARTITION BY <range> Possible

  I've come across some code that fills a temp table in 3 parts CREATE TABLE #Tmp ( pKey INT, Sor…

  Tom257

  2 replies

  13 years, 6 months ago

  By: drew.allen

• filter by calcuated feild?

  I have a table with a list of unix timestamps. i'm trying to figure out how to list all values new…

  foscsamuels

  14 replies

  13 years, 6 months ago

  By: Sean Lange

• Very strange question ... with an unexplainable solution

  Hi all, Got a bit of an odd one here. I have a problem, which I have several solutions for. I just …

  kramaswamy

  4 replies

  13 years, 6 months ago

  By: kramaswamy

• Get result based on competition like FIFO

  I've tables and data as following, declare @t1 table (idx int identity, programID int, quota int, f…

  Qira

  4 replies

  13 years, 7 months ago

  By: Qira

• Not able to handle duplicates whild updation. Not as simple as you think..

  I have a problem with a data correction procedure. The username / password policy of company is cha…

  SQL Kidu

  4 replies

  13 years, 7 months ago

  By: J Livingston SQL

• Stored Procedure Parameters

  Hi all, In below code DbCommand dbCommand = db.GetStoredProcCommand("saveUpdate"); d…

  MuhammadShafiq

  1 replies

  13 years, 7 months ago

  By: Ron McCullough

• Horizontal filtering(or way to say it)

  Hello all, I've been diggin it everywhere but can't find result, maybe i am searching for the wrong…

  diditheouf

  1 replies

  13 years, 7 months ago

  By: Evil Kraig F

• IF (1=0) BEGIN SET FMTONLY OFF END

  Sorry for the rather undescriptive title, but I am not sure what to call this problem, aside from g…

  loki1049

  10 replies

  13 years, 7 months ago

  By: Andre Guerreiro

• Multi-Database View in SQL Server 2000 - Restricting Permissions

  Our payroll company stores detailed payroll for us in a SQL Server 2000 database (there's no chance…

  jvanderberg

  4 replies

  13 years, 7 months ago

  By: Elliott Whitlow

• PIVOT Function ?

  Hi, I have data in following format from my variable table ID ! TEXT --------------------…

  SQL_path

  1 replies

  13 years, 7 months ago

  By: GSquared

• Summation of amount in T-Sql

  Hello! Please run the queries below to get along. The users of the tables below want to see accurat…

  SaintGr8

  17 replies

  13 years, 7 months ago

  By: SaintGr8

• lost bytes - BULK IMPORT

  Hi, I've got a problem with importing file. My web application store users files as data type image…

  bpecak

  1 replies

  13 years, 7 months ago

  By: PhilPacha