Topics
Started by
Posts
Last post
How do I use a lookup table (on SQL SERVER) without hardcoding the (business rules) values within S…
2 replies
((@VarEmp_Id=0) or (@VarEmp_Id is null)or (Employee.Emp_Id=@VarEmp_Id)) And (Emp_Nam…
2 replies
I hope you guys can help me, I’m stumped This is on SQL SERVER 2000. I want to process id’s in a …
8 replies
In my environment I've seen: 1. WHERE ISNULL(burgertype, 'Bison Burger') <> 'Cheese Burger' 2…
4 replies
I have 3 tables where Tables A and B with column Timelogged and Table C has same time Timelogged as…
1 replies
Hi all, There was some requirement from my client and i give them the required information. but her…
9 replies
I want to remove duplicates from the DB. here's my code for that: DECLARE @Count int DECLARE @compa…
33 replies
Hi Guru, I have two tables (AddressInfo and PracticeInfo) and below are tables structure: AddressIn…
7 replies
There's a very simple way to do this, but I forgot what it was. A good example of the problem is a …
10 replies
Is there is any way to break / avoid the recursion in the CTE QUERY?? Abhijit - http://abhijitmore.…
5 replies
/* Problem: We have a service that runs n times an hour. i need to know how many times it runs. …
7 replies
I am just a starter in SQL and I'm maintaining a Live DB in which every day some records upserted/d…
1 replies
I Use This Codes But Got Error Too {---My Code USe Mg Go Declare @CDate nvarchar(max); Declare @VDa…
5 replies
The book I'm reading says that you can JOIN in either the FROM or the WHERE clause but gives no exa…
11 replies
Table has two columns Name and ID. ID (int,not null) Name (nvarchar(255),not null) I need a SQL scr…
2 replies
Viewing 15 topics - 9,016 through 9,030 (of 10,635 total)
You must be logged in to create new topics.