Topics
Started by
Posts
Last post
Hi, We all know that DISTINCT clause will provide unique resultset (means removes the duplicate row…
15 replies
I have a linked server that contains multiple databases. One of the databases is only showing 5 ta…
3 replies
Hi, I have just played around with an UPDATE statement... CREATE TABLE updater ( col1 INT, col…
3 replies
I am doing a project where I need to Mark similar records in a table with millions of records. By s…
21 replies
All, What's the best way to update thousands of records to remove leading '00's from account number…
1 replies
Is there any advantage/disadvantage as far as rendering, performance, etc. by using either select c…
3 replies
I have following table create table catProblem (CategID smallint,CategName varchar(30),parentid sma…
4 replies
Hi, I have write this function in SQL Server 2008, but now I'am trying to compile this procedure in…
2 replies
I have have table that I need to get refreshed from another database. I thought it would be as eas…
10 replies
I'm trying to validate a text field that may contain the CustomerNo in it to be all numeric but the…
16 replies
So I don't want to start another debate about the best way of doing the whole comma seperated list …
2 replies
Hi, i have created some stored procedures in the sql server 2005 database for the application r…
1 replies
My latest challenge is trying to join three tables. This should be a simple task but for some reas…
3 replies
Hi when i have restored database from production to UAT .as production users will be different for …
3 replies
I have a script that finds the 2nd period and returns the first and second nodes in a string. It w…
4 replies
Viewing 15 topics - 4,471 through 4,485 (of 12,234 total)
You must be logged in to create new topics.