T-SQL

• Topics

  Started by

  Posts

  Last post

• Cursor Cursor Cursor - need help

  What I'm trying to do is create a table that has the tables with in a certain Database on my server…

  dwjongbloed

  1 replies

  16 years ago

  By: Garadin

• How do I

  How do I.. select * from loan where branchoffice <> ('01','02') obviously this does not work..

  krypto69

  2 replies

  16 years ago

  By: krypto69

• Workaround needed for SQL Server 2000 limitations, when data collected from many servers

  Dear All, I have the following problem: A client (asp code) is calling a stored procedure on Server…

  gabor.kaszas

  12 replies

  16 years ago

  By: gabor.kaszas

• time formats

  my current time format for a column regdate is 2004-01-20 10:09:18.000 2005-02-15 20:09:10.000 2006…

  mtz676

  5 replies

  16 years ago

  By: Johan Bijnens

• Need some reporting help

  Hello all! I am stuck on this one. I'm trying to replicate a report for a user. The report looks li…

  douglas.dawson

  1 replies

  16 years ago

  By: Florian Reischl

• grant exec on user SS2000 in stored proc

  I am using SS Mgmt Studio 2005 against a 2000 db. I write stored procs and the sys admin wants me t…

  gardenlady

  9 replies

  16 years ago

  By: Garadin

• How To UPdate the Multiple Record

  Dear All; Pls Help This To Create The SP 🙂 The Table Like this Id RegNo Name Doe 1 001 Vin…

  sqlfriends@sql.com

  7 replies

  16 years ago

  By: Florian Reischl

• Help in writing Query for hall booking date availability search

  I need help in writing query to find the time slot availability for a hall booking system.. details…

  Anzer Muhammad

  6 replies

  16 years ago

  By: Sergiy

• Selecting lowest value with group by

  From the table below I am trying to: SELECT [id], [origin_latitude], [origin_longitude], [remote_la…

  Jonathan Turlington

  4 replies

  16 years ago

  By: Sergiy

• Invalid length parameter passed to the substring function

  Hi,   I found an SP on the net (http://searchsqlserver.techtarget.com/tip/1,289483,sid87_…

  Eoin The Forge

  5 replies

  16 years ago

  By: Sergiy

• grant exec on user SS2000 in stored proc

  I am using SS Mgmt Studio 2005 against a 2000 db. I write stored procs and the sys admin wants me t…

  gardenlady

  1 replies

  16 years ago

  By: Gail Shaw

• List parent with childs

  Can someone help me writing a storeproc that will list all parents with is child (sub-parts), level…

  Stanley Pagenel

  2 replies

  16 years ago

  By: Stanley Pagenel

• bug with sp_msforeachdb?

  Hey people, I have an interesting issue that I cannot seem to figure out. I am using the undocumen…

  Doug

  7 replies

  16 years ago

  By: Doug

• SQL Locks

  I tried the following, and expected, that if I run two instances of the .exe, then one of them shou…

  pgpatrudu

  5 replies

  16 years ago

  By: pgpatrudu

• How to Get a ResultSet Count

  Dear All; Pls Help this; How to get the ResultSet Count IN SQLSERVER 2005

  sqlfriends@sql.com

  7 replies

  16 years ago

  By: arun.sas