Topics
Started by
Posts
Last post
Hi, I've been looking at previous posts to try and figure out how to get my query to return the mos…
6 replies
Hi, I have a column that has values: 61205 60606 20712 and I need to create a new column th…
7 replies
I need to rewrite the following SELECT statement to omit the non-ANSI LEFT OUTER JOIN symbol *=&nbs…
2 replies
I can get the database name from DB_Name() BUT how can I get the Server name? Thanks, Phil
4 replies
When I try to filter a table on a date field in an open table in SQL 2005, it takes a very long tim…
10 replies
I know when you create a partition you define the range, but with numerous merge and split statemen…
1 replies
I am trying to create a query to look for any expression that contains a lowercase character in the…
9 replies
Hi, I want to know if anyone can help me trim values of comma delimited types into multiple rows. B…
1 replies
This error message : Cannot find the certificate 'AccountingCorp', because it does not exist or you…
1 replies
Hi Friends, In my table i have column street_number what i need is if the street_number <> 0…
3 replies
Hi ppl, First post so hope its in the right place. Run into a problem. Have to design a db with it…
3 replies
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
Viewing 15 topics - 11,971 through 11,985 (of 12,230 total)
You must be logged in to create new topics.