I prefer Notepad++ for reading most logs, actually I prefer it for reading anything.

Do you have indexing on any of these tables? I ask because of memory allocation requirements on higher DoPs.

From: http://technet.microsoft.com/en-us/library/ms190787.aspx

For both aligned and nonaligned indexes, the memory requirement can be...

Crystal accepts a command per select. If you have multiple select statements in a custom crystal command it will only read the...

You may find this site useful for basic SQL commands: http://www.w3schools.com/sql/sql_insert.asp

Below is a direct quote.

We can use the following SQL statement (without specifying column names):

INSERT INTO Customers

VALUES ('Cardinal','Tom B. Erichsen','Skagen...

I haven't been around on these forums for too long, but boy have I seen a lot...

I wish this just returned a random value just to mess with people who...

Lowell (7/24/2013)

---

its a binary AND operation.

5 = 00000101

17 = 00010001

the only column in BOTH values binary representation above is the first column, representing 2^0, so the value is...

This would be my go-to if I didn't have an audit server setup for the database. It's not...

tempdb will be used as required for temporary storage.

There's a good chance you have a SProc or some query that's generating a huge amount of temp storage that's requiring a...

The first thing that pop'd into my head was that the temp tables are probably declared differently. Sure enough http://www.sqlite.org/tempfiles.html shows that temp tables are declared with the syntax "CREATE...

This copy paste is barely legible, you've got column headers on a line and then a run on sentence of information that isn't even formatted to be read. Heck one...

To obtain data from a stored procedure you need to have a select. A function can 'return' data if that's what you're looking for-- If you're looking to return something...

It's hard to really reply to what you're saying without seeing it. Is each variable inside a different while loop? Post an example, or better yet, post what you've written...

immaduddinahmed (7/19/2013)

---

I AM MAKING A APPLICATION IN c# THERE IS A GRID THAT SHOWS

SHIFT ID , SHIFT AND DATE

USER SEARCH DATE AND IN GRID DATE , SHIFT AND SHIFT...

So post it.