Programming SQL

Fast SQL Server Stored Procedure runs slow in VB.NET
Our application uses VB.NET 2008 and SQL Server 2000. I can run the SP fast in the SQL Server Management Studio or SQL Query Analyzer window. But, when running it in the VB.NET program, it is very slow. Why is it slow in the program ? Is there anything else that I could do ? Thank you This is the VB6.NET ... 19 Apr 2010 09:30

running total column help
Hi All, rule: T-SQL prior to SQL2005 Given this: row, amt, run$ ---------------- 1,$15,NULL 2,$0,NULL 3,$10,NULL 4,$15,NULL Transform to this: row, amt, run$ ---------------- 1,15,$40 2,$0,$25 3,$10,$25 4,$15,$15 Basically, is there a way to populate the run$ col with a running total Thank... 16 Apr 2010 23:59

rebuild reorg proc
Hello all, SQL server 2005 Std edition X64 SP3 CU6 running on Server 2003 Ent Edition SP2 32 GB RAM 2 X quad core procs. AM using a commonly available Stored Procedure to rebuild\reorg indexes based on criterion. Unsure where the original came from but I got this copy from the Web. Please consider this credi... 19 Apr 2010 05:21

Timestamp default value
Unlike other databases (eg. PostgreSQL and ANSI SQL), TIMESTAMP in SQL Server is not the same as DATETIME. The value contained is changed on every update and is used for row versioning/optimistic concurrency. DATETIME is what you need. In the future, Microsoft may rename TIMESTAMP type to ROWVERSION. Erland S... 16 Apr 2010 15:07

year week table help
Hi All, Given: year = 2009 week = 3 How would I build a temp table of year/week values 27 weeks back. for the example above: 2009, 3 2009, 2 2009, 1 2008, 52 2008, 51 .... (Also, doesn't some years have 53 weeks?) thanks, rodchar ... 16 Apr 2010 17:21

is it necessary to drop temp table in stored proc
Hi All, IF object_id('tempdb..#TEMP_CORE_DATA') IS NOT NULL BEGIN DROP TABLE #TEMP_CORE_DATA END Is the preceding sql necessary when the temp table is put in a stored procedure? thanks, rodchar ... 19 Apr 2010 14:41

Que Assignments
Sql Server 2000 I have a table called tblAccountNumRecords that contains an integer field called "MREmployeeID". This table contains (Variable) 20,000 records each day and is purged at the end of the day. I have a table called tblEmployees with a integer field called EmpID and a text field called "W... 16 Apr 2010 01:52

SQLCLR Table-Valued Function and NULL value
I have a CLR UDT function with the following signature: [Microsoft.SqlServer.Server.SqlFunction( DataAccess = DataAccessKind.Read, FillRowMethodName = "LedgerDataFillRow", Name = "PAS.Transfer.SunSystems.LedgerData", SystemDataAccess = SystemDataAccessKind.None, TableDefinition = SUN4_LEDGER_TABLE_DEFINITION )... 16 Apr 2010 10:36

vary the select statement in a from clause
hey all, i have a sql like so: update mytable set mycol=val from ( if (cond) begin select myval from t1 end else begin select * from t2 end ) tbl is there a way to make the if(cond) work? probably doesn't look like a good idea anyway? thanks, rodchar ... 16 Apr 2010 10:36

SP in IN clause
Is it possible to use a stored procedure inside an IN clause? For example below, the stored proc returns a single column of TimeID values. SELECT TimeID FROM dbo.Timesheets WHERE (TimeID IN(EXEC mc_selDuplicateTimesheets)) Or is there another workaround? Thanks. -- David ... 16 Apr 2010 10:36