Topics
Started by
Posts
Last post
With the formula below what does the (1.0) mean? (isnull(([UnitPrice]*((1.0)-[UnitPriceDiscount]))*…
5 replies
Is there a way to disable error checking when creating a Stored Procedure in SQL 2005 or when a par…
4 replies
Ok, this has me completely baffled. Why do these two queries return a different count (first:168, …
1 replies
Hi, I am using the gollowing query Select 'update env_usage SET quantity='+cast( quantity as varcha…
2 replies
I have a table with a trigger on it that sends some data to a stored procedure when data is inserte…
2 replies
Hi, I have a column that is being called a julian date format although is not "true" julian date an…
2 replies
Hi, In SQL Server 2000 I used a simple query to list all server roles members: select a.name RoleNa…
1 replies
Hello everyone, I have a DDL trigger that theoritically protects my Server from altering …
2 replies
hi all, quick question given the following data ABC - xxxxxx DEF - xxxxxx XXY - aaaaaa aaa-ddd-fgg …
2 replies
Hi All I have the following resultset: PCName ObjName PerfName Date &n…
6 replies
I have a table that contains a SortOrder field that allows the user to re-arrange the order in whic…
16 replies
I have an email table that i am building and i would like to update a record when a user replies to…
3 replies
Below is the code if i run this on SQL 2000 & 2005 i get different output, can any one tell me …
6 replies
I have a SQL that get me a count of rows that have a column name = the parameter that i am passing …
2 replies
I need to retrieve the point in time cost of an item from a cost history table. The table has…
1 replies
Viewing 15 topics - 11,986 through 12,000 (of 12,234 total)
You must be logged in to create new topics.