Topics
Started by
Posts
Last post
Hi All I have a table as below Create Table #Temp1 ( ID int,Dep int,Key int) Insert i…
4 replies
I want to add the procedure in all database, is it possible to add it using sp_MSforeachdb. If poss…
17 replies
How to improve the performance by using indexes in sql server 2005 Can you explain?
2 replies
I had created following table Create Table emp(empid int,ename varchar(30)) Insert Into emp values(…
2 replies
First SP is used to check how many tables Referred and return the Referred tables names Second SP ,…
1 replies
First SP is used to check how many tables Referred and return the Referred tables names Second SP ,…
1 replies
Hi Guys I have got this query where I am using union all to combine different dates. These dates ha…
1 replies
Apologies if anyone just looked at this in the 2000 forum, it wasn't until I saw the Control Panel …
14 replies
This doesn't seem like it should be this hard... maybe it's just a Monday thing. I've got some dat…
5 replies
select distinct A.Col1,A.Col2,A.Col3,A1.total as [current_month] ,A2.total as [current_month-1],A3.…
2 replies
As the description reads, I need to search every column in a database, I've done some web searchs a…
21 replies
To multilpy TotalLoans X .06 do I use set @TotalC1 = ((@TotalLoans * 0.06)) OR set @TotalC1 = ((@To…
2 replies
I am trying to enter data into product id's that correspond to a category id in a different databas…
3 replies
I have a front end application which has 4 checkboxes . Each checkbox corresponds to a column in th…
2 replies
I've a fair number of tables in my various databases, which are there for the sole purpose of accom…
5 replies
Viewing 15 topics - 5,386 through 5,400 (of 12,234 total)
You must be logged in to create new topics.