Programming SQL

Query Help
Hi All I have a table as follows col1-----col2-----col3-----col4 --------------------------------------- 30 1 11 111 30 2 22 222 30 3 33 333 Now i want 2 query on this table so that my output should be as follows 30 1 11 111 2 22 2... 8 Jul 2008 06:57

Encrypting fields in SQL 2000
I need to encrypt some fields in one of my SQL 2000 databases. The fields are decimal fields and I need to be able to decrypt them too, so a one way hash is no good. I want to encrypt/decrypt these fields from within stored procedures but am unsure how to go about doing it. Can anybody offer me any advice pleas... 8 Jul 2008 05:55

Linking Table to Output of TVF is Very Slow
Hi I have a query on a main table that takes a small number of seconds to run. I want to link it to a TVF, but when I do the performance is appalling. There are actually two qualifiers on the join, like this SELECT * FROM MainTable MT INNER JOIN MyTVF(@Date1, @Date2) TVF ON TVF.SomeID = MT.SomeID AND MT.T... 10 Jul 2008 04:09

Please help :)
Hi I hope someone has the method to create the running calendar there are same amount of days the last date is today and start day (today - 6 month) Please let me know about this running calendar Thank You in advance Peter -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sq... 9 Jul 2008 07:32

SQL diuplicat query
Hi i'm trying to reproduce this query using temporary tables, i need to make it faster SELECT rough_ID, naasra, road_ID, end_m, direction FROM rough WHERE EXISTS (SELECT * FROM rough AS TWD WHERE TWD.rough_id <> rough.rough_id AND TWD.Road_ID = rough.Road_ID AND TWD.end_m = rough.end_m AND TWD.Direction = ro... 8 Jul 2008 17:13

DateTime conversion question
I have 2 tables: Table1 .... LastModifiedDate DateTime .... Table2 SettingName nvarchar(50) SettingValue nvarchar(50) In table1 the LastModified column of my rows are by default (I'm in Belgium) in the format dd/mm/yyy hh:mm:ss. In table2 when I store a GETDATE() in the SettingValue column the format is... 8 Jul 2008 21:20

Specific records based on date (Today & yesterday)
I have a webform that enters records into a basic database. I would like to retrieve every record that was inserted today as well as the last one from the previous day. Any suggestions? ... 8 Jul 2008 07:58

Stored Proc Help...
First here is the Proc I have so far.... set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go create PROCEDURE [dbo].[type_check2] @name VARCHAR(30), @result VARCHAR(3) OUTPUT AS DECLARE @namecount int BEGIN SET NOCOUNT ON; SELECT @namecount = count(*) FROM dbo.warehousetype WHERE name... 16 Jul 2008 10:56

Restricting output of view to eliminate rows having duplicate
Thanks Tom for your help. I appreciate it very much. Regards. "Tom Cooper" wrote: You didn't specify your version of SQL server The following works on any version of SQL Select v.Part#, v.Project#, v.ModDate, v.Status From YourView v Where v.Moddate = (Select Max(v1.Moddate) From YourView v... 7 Jul 2008 17:40

best datatype
Hi all, I need to upload a file from .xls that have following columns: Emp Dept A 5 B 6;8 C 6 D 7;4;8 When I uploaded using datatype varchar or text, the columns having single data like first and third columns appeared as NULL. So, I was just wondering what could b... 7 Jul 2008 16:38