Programming SQL

2 questions not posted
I posted a question last night about the error "The query processor could not produce a plan..." but it didn't show up here. I've never had that happen before. It's in my sent items (in OE). I posted it a 2nd time with a slightly different subject and it's still not here. I don't find them when I hunt for them ... 19 Feb 2010 07:39

Transfer file from Access to Server
I work with Access 2007 as a front end to a SQL Server backend. I would like to be able to select a file from my local desktop, then, through VBA/SQL transfer the file to a folder on my server. Or, store the file in a varBinary(MAX) column in a table, but then use a SPROC to take the file out of the table a... 19 Feb 2010 02:13

Reservered Words
Is there a link available for reservered words Can a field be named GROUP or is it a reservered word? TIA ... 24 Feb 2010 03:10

C# and SQL Server: Parallel vs. Sequential Writes (?)
Consider: - My SQL Server has 8 processors (cores actually). - I want to upload 8,000 records to a single table in my database. Which of these two would get the job done faster? (a) spawn 8 different threads in my client application and, using eight different sql connections, upload 1,000 entrie... 25 Feb 2010 20:31

PHP Tutorials
<a href="http://phpforms.net/tutorial/tutorial.html">PHP Tutorials</a> Yuriy Krapivko wrote: PHP tutorials 17-Feb-10 PHP tutorials http://phpforms.net/tutorial/tutorial.html Previous Posts In This Thread: Submitted via EggHeadCafe - Software Developer Portal of Choice How to Annotate Images f... 17 Feb 2010 13:24

Ranges in query
Hello, My requirement is to create a pivot report in which a column called indexrange is to be displayed as n number of intervals eg: 0-9, 10-19 etc. The source of data for the pivot is a SQL Server query. I am not sure where or how can I do it, so I am posting this in both groups. Is it possible to take a... 18 Feb 2010 10:36

CTE and 2 selects from it
I have comon table expression and I would like to select 2 different recordsets: ;WITH transports AS ( SELECT o.transportID, o.izd_id, quantity, valueQ, ROW_NUMBER() OVER (ORDER BY izd_id DESC)AS row FROM @transportID t INNER JOIN dbo.transportOrder o ON t.transportID=o.transportID ) SELECT * FROM tra... 19 Feb 2010 04:23

creating a start and end date table
Hi All, Below is a SQL CTE that takes a start and end date and creates a table of bi-weekly start and dates within the date range. Are there any other ways to write this? More concise? (not saying that it isn't concise because I don't know) ;WITH cteTally AS ( SELECT ROW_NUMBER() OVER (ORDER B... 17 Feb 2010 15:39

Conversion of int to number
Is their is any method or procedure(Logic) to Convert my int input to String e.g. if i input Number 1 then output should be One if 2 then Two and so on ... 17 Feb 2010 11:06

About Autonumbering
i Have an Column Having DataType is Integer.and Column is Auto numbering.Can I Check any how in database If Nay Number got deleted then Numbering Should not be rendered e.g If No Assigned Are 1,2,3,4,5 As if No 4 gets deleted then 5 should go to 4 and New No should be Assigned as 5 ... 19 Feb 2010 15:32