Programming SQL

Speed Up OPENROWSET?
I have a SQLEXPRESS 2005 database linking to an Access 2003 file using the following statement. The response is very slow. Is there any way I can speed this up? CREATE VIEW [dbo].[MyTable] AS SELECT FIELD1, FIELD2 FROM OPENROWSET 'Microsoft.Jet.OLEDB.4.0', '\\MYSERVER\MYSHARE\MYDB.MDB'; 'admin'; '', MyTable)... 1 Dec 2009 18:27

computing a counter/counting column?
The following table (query) lists individuals once, twice, three times, or more. I need to compute/derive the count (the progressive count - incremented by one for each person) of each entry for each person -- the count to be displayed in the computed/derived column which I will call "Attempt". Fred is listed... 1 Dec 2009 17:19

SQL Server Profiler Determine Number Times User Account Used
I have numerous SQL Server 2005 Profiler traces that run when certain user account are used in the database server in the last month. Please help me with a program to determine the number of times and duration the user account has been used in a database server? Please help me resolve this issue. ... 1 Dec 2009 09:25

TSQL Challenge 18 - Generate text formatted month calendars
http://beyondrelational.com/blogs/tc/archive/2009/11/30/tsql-challenge-18-generate-text-formatted-month-calendars.aspx I didn't think this was possible: TSQL Challenge 18 - Generate text formatted month calendars declare @t table (Mth int, Yr int) insert @t(Mth, Yr) select 8, 2009 insert @t(Mth, Yr) select 2... 9 Dec 2009 16:41

Setting of @@FETCH_STATUS
I have a snippet of code from a trigger: DECLARE @Saved_ID int SET @Saved_ID = (SELECT max(ID) FROM Table WHERE Name = @UserName) IF @@FETCH_STATUS = 0 AND @Saved_ID IS NOT NULL UPDATE ELSE INSERT Turns out my code ALWAYS runs the INSERT. If I add a temporary variable: DECLARE @Saved_I... 30 Nov 2009 14:45

Insert query using date as where condition
I have an insert query that runs every day at midnight that records our client's current environmental status (it's for a mental health facility). Here's the code: ----------------------------------------------------------------------------------------------- INSERT INTO dbo.tblCensusHistoryWithDischarge (FullNa... 30 Nov 2009 00:31

Time data type
I am using SQL server 2008 The following command: CREATE TABLE Table1 ( Column1 time(7) ) results in the following message: Msg 2715, Level 16, State 7, Line 1 Column or parameter #1: Cannot find data type time. Please help. Thank you ... 30 Nov 2009 03:44

using CLR that returns table
Hello there. I need to build CLR which gets text and converting it to table. this CLR should run 10 times in one second. By default(as far as i know) the retuned table of CLR is saved to temp db like any other table valued function. This can cause to system to work mutch slower then it is. Is there a w... 30 Nov 2009 15:52

Select Query Problem
hi all The table have lots of duplicate rows except for the last column skills The skills has diffrent values some rows 'Middle East' and the other rows 'Resident Engineer', 'planner' etc When the user enters the name and the skills set, he wants to see thouse who has all the skills set Table sample N... 26 Nov 2009 12:00

Casting to VARCHAR(MAX)
Thank you very much for your reply In my previous post it was just a simple simulation to reproduce the scenario. But my real working scenario is a bit more complex. I am combining a few values dynamically and the final result is inserted into a column of a table. Like the following query. CREATE TABLE #TEMP1... 20 Nov 2009 05:41