Topics
Started by
Posts
Last post
I have two separate Insert and Update stored procedures and I am looking for a way to add a Variabl…
7 replies
I have a reindex job that seems to get into a deadly lock with an application. Essentially, on the …
8 replies
[font="Arial Black"]Regarding this book:[/font] Beginning T-SQL with Microsoft SQL Server 2005 and …
2 replies
Hi, I'm doing some testing with dynamic filtering and order by clause. I'm comparing dynamic SQL vs…
18 replies
Anyone knows in a stored procedure that has code like below: .... set @TranCount = @@trancount if n…
6 replies
I think that I'm having a end of the week, mind meltdown kind of moments. I have a table that has …
3 replies
create table dbo.employee ( empid int primary key, name varchar(200), city varchar(100) ) select * …
8 replies
Please help me to update update tblAverageMonthlyConsumption set region=(select distinct A.region f…
5 replies
Hi All, I am using the session variable context_info to log changes made to data in an audit databa…
13 replies
hello Sorry, I'm Convert one of the fields of Table Nvarchar(10) to integers Please help me
1 replies
I have few tables that I want to capture who did the last update on them. For that I created a coup…
6 replies
All, I have read and asked lot of questionss about "Multiple space into one" here. I just thought t…
40 replies
Would be interested to hear on some of the best ways to approach this situation. I've recently star…
20 replies
My input Looks like this CREATE TABLE #DataToBeReOrdered ( EmployeeID INT, Name NVARCHAR(100), Mana…
2 replies
How do I convert days into weeks and days Ex:350 days = 50 0/7 weeks 351 days = 50 1/7 weeks …
9 replies
Viewing 15 topics - 5,026 through 5,040 (of 10,647 total)
You must be logged in to create new topics.