Topics
Started by
Posts
Last post
This SQL statement SELECT MAX(DISTINCT ProductVersion) AS New, ProductType,…
6 replies
I am getting an average in a group by. The number stored as an int. It is currently rou…
4 replies
Is there a way to make a script that can take a record from one server and store this in a script t…
1 replies
Hi, I am using IS NOT NULL and getdate() in my stored procedure. See the code snippets below and ad…
1 replies
I need to extract data from a sql server table and format the date so that oracle can read as in dd…
6 replies
Hello - I am trying to set the value of 4 variables based on the format of one main variable. DECLA…
2 replies
Is there any fundamental difference between a PRIMARY KEY and a UNIQUE CLUSTERED INDEX? In MSDN (un…
1 replies
The manual says that if you put a ROLLBACK TRANSACTION in a trigger it will abort the batch as well…
1 replies
I would appreciate if someone can help me with SQL or something which would help me delete dup…
10 replies
Hi all, Man this has been a frustrating day. I think I've gotten to the root of the latest p…
1 replies
Hello, I'm try to build a query to find missing Ids on a table. Anyone knows if there's a way of do…
8 replies
I have an application that regularly passes queries that are cartesian products. I am trying …
1 replies
Is there a simple way to test for the existance of a table?
3 replies
How can I obtain a list of columns (and column properties) that are output by a stored procedure? I…
1 replies
Hi friends following query gets me list of assignments and timespent on them so far select fk_assid…
2 replies
Viewing 15 topics - 12,751 through 12,765 (of 17,082 total)
You must be logged in to create new topics.