Programming SQL

Preaching does not help
It would help the community quite a bit if people would stop preaching about how things are supposed to be in a perfect world, and just answered the question directly. I'm really tired of reading the same opinionated babble from engineers who clearly lack the experience to address real-world issues. ALL code is... 17 May 2010 04:48

Blocking with a View
This makes no sense to me. The SELECT below SELECT SE.* FROM vw_UKSEAT SE WITH(NOLOCK) JOIN vw_UKTrans T WITH (NOLOCK) ON SE.AccountDate = T.AccountDate AND SE.VaxEvid = T.VaxEvid AND SE.VaxAcct = T.VaxAcct AND SE.TransNum = T.TransNum WHERE T.Transdate >= ' 01 Jan 10' AND T.TransDate <= ' 20 Jan 10'... 12 May 2010 19:14

REPOST: basic question re select
Sorry, did the accidental keystroke for send message....oops So how do I select records from a table where a field has a value or is null. I tried : select * from tbl_article where lift in(1 ,null) but that didn't work... ... 12 May 2010 09:09

basic question re select
Hi, I am trying to select all the records from a table where a field has a certain value or is null. I tried : ... 13 May 2010 11:37

SQL Agent CmdExec step and environment variables
Realize this is a bit old, but I had this problem and I managed to find a way around it. I just preceded the command with CALL. Hope this helps someone else. i.e xcopy "%COMPUTERNAME%\folder\*.*" "destination" CALL xcopy "%COMPUTERNAME%\folder\*.*" "destination" From http://www.developmentnow.com/g/113_2004_11_... 11 May 2010 22:20

connection status "suspended"
I am using SQL 2005. Starting from today, when I do sp_who, every few minutes I see a new connection to the database and the status is "suspended". This new connection comes from the same VB.NET program that inserts data to the database. After a while, the program will get the error "Timeout expired. The timeou... 12 May 2010 04:49

Help on simple SQL statement
Hello, I am having a problem with my SQL statements and I need a pro on this one. I have two tables 1. SalesHeader 2. SalesDetail. I join these two table together (code below) Here is my problem when I have the same invoice number with multiple LineNo I want to display only the AmountShipped field not ... 13 May 2010 11:37

SQL query help
Hello everyone, Here is a sample table I have. I need to group by the product and display by a range. |ProductA | ProductB| ProductC| ProductD| ProductE| --------------------------------------------------------------------------------- | 1 | 5 | 7 | 6 | 3 | |_______________|_______________|_____________... 12 May 2010 17:00

SQlServer2008\DateStoredAsVarChar\QueryHelp
I am using SQL Server 2008. I am runnung a SQL statement against several tables. The data for the most part is all stored in varchar fields. I cannot change the datatypes. it is a commercial application and I would break it. Anyway one of the fields (Add_Date) stores a date like this 11/22/2009. I need re... 13 May 2010 09:23

FILESTREAMING SQL 2008 R2
Hi all, I am using filestreaming technology for saving images into database, my issue is when im altering tbl structure like adding a column, then link goes break and , new folder created, when im rollbacking then file still exist on the same folder, pls help what is going wrong with me These all tak ... 11 May 2010 07:51