Programming SQL

Performance problems after upgrading to 2005 from SQL 7
Hi, The following piece of SQL takes more than 2 minutes in 2005 whereas it takes less than 10 seconds in SQL 7 - --ORIGINAL IF ( SELECT COUNT(*) FROM OrderRecords o JOIN Batches b ON o.BatchID = b.ID JOIN ProcessGateways pg ON o.GatewayID = pg.GatewayID AND pg.ProcessID = @lngProcessID WHERE o... 15 Jul 2008 11:17

Copy Data (attempt 2)
(Apologies if this is a repost, my first hasn't shown up after 4 hours) I'm trying to create a table variable which matches the schema of an existing table with an added 'NewUid' column, and I want to populate it with select data from the live table, and then insert this data back and populate the NewUid colum... 15 Jul 2008 11:17

'sp_send_dbmail'
I need to allow some users to run a script once a month that involves calling 'sp_send_dbmail' to communicate progress. What is the best practice method for giving users access to a system SP like this? I guess I can probably go into each ones server account and do it there? TIA Nigel Ainscoe ... 16 Jul 2008 13:01

Row To Column
Hi, I want to get following output: Create Table RowToColumn ( Col1 Int, Col2 VarChar(10), Col3 DateTime, Col4 Numeric(20,10) ) Go Insert Into RowToColumn Select 1, 'A', '20080714', 10.2 Union Select 2, 'B', '20080715', 11.21 Required Output : Where Col1 = 1 ColumnName Value Col1 1 Col2 ... 15 Jul 2008 09:12

Trigger when connection ended
Hi I would like to operate a v.simple locking mechanism. Have a hierachical db structure everything hangs of customer table. So when someone is editing a customer do not want anyone to be able to edit the same customer. One way would be to store customer id in table with user currently editing it. Gets cleare... 15 Jul 2008 17:30

Mimicking Access Cross tab query
Hi I recently came across the PIVOT sql syntax. Less typing than select case. Access has a crosstab query to turn values that appear in rows as columns. this has the advantage over SQL in that you don't need to declare what column headings you want. E.G. say my crosstab or pivot query had a new product = "ble... 15 Jul 2008 21:37

Numbering rows leader-board style
I'm wanting to get a ordered table of players and their scores, in descending order, with a a leaderboard style row-numbering (so of two people had the same score they would both be position 3, and the next would be position 5). I've managed to find a way using a side-effect of another article's method of getti... 16 Jul 2008 09:54

Table Data
Hi Guys I have table Classification. In this table one column like Definition That columns contains the data like Definition ---------------- Datetime10, Datetime1 Varchar10 Varchar1 Numeric1 Numeric10 But i need the data like this Definition ---------------- Datetime Datetime Varchar Varc... 15 Jul 2008 10:14

table variable - get the structure from an existing table
Hi all, Is it possible to declare a table variable and get the structure from an existing table? Something like "select * into @my_table" or any other recommended way Thanks, Avi ... 15 Jul 2008 11:17

Help
Hi Guys Declare @var varchar(200) SET @var = 'varchar1,varchar10,varchar15' But i want like this @var = varchar,varchar,varchar any one help on this thanks Rakesh ... 15 Jul 2008 07:10