Topics
Started by
Posts
Last post
Here is a condition: create table T1(Proc1 varchar(20), Proc2 varchar(20), Status varchar(20), Mdat…
1 replies
Dear Experts, I have the following table structure ID int primary key date_modified datetime firstn…
1 replies
I have little to no SQL experience so bear with me on this. Basically I have some software that exp…
5 replies
Hi Team, As Many of us know that Datatypes Play key role in the performance .. So I got a Task wher…
9 replies
the below "if (db.ExecuteNonQuery(dbCommand) > 0)" returns -1 public static bool IsUserInFavori…
1 replies
Hi, Reporting services Group is not calculating by group. =count(Fields!GMPI.Value) *900 for group …
2 replies
Hi All I was just thinking of using a table variable instead of temp table to see if it gives any p…
1 replies
--Create Parent Table CREATE TABLE [dbo].[Parent] ( [Parent_ID] [int] IDENTITY(1,1) primary key cl…
28 replies
I have a situation where I need to calculate the avg sal only when I have a recent value. i.e, tabl…
9 replies
If I wanted to calculate the average run time for a given SQL Agent job over the past month...knowi…
1 replies
Hi alll, i am using sql server 2005, How to add date and time for exampleeeeee my date fil…
7 replies
I've got a stored procedure that has 19 different parameters, all of them optional. The query that…
1 replies
I am trying to pinpoint the cause of a deadlocking issue in one of our tables' triggers. DISCLAIMER…
1 replies
Hi there, I have a set a data with the same data in all columns besides the tel no column and un. I…
1 replies
Hi All I have a rather easy looking yet complex sql query. Just wondering if anyone could shed some…
12 replies
Viewing 15 topics - 751 through 765 (of 4,155 total)
You must be logged in to create new topics.