Topics
Started by
Posts
Last post
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
I have a question about identity seed. We have a table that has 4300 records with a surrogate key 1…
8 replies
I have a query that I'm trying to get the sum of sales for a rolling 12 months and after doing some…
8 replies
Hi, I use CTE with ROW_NUMBER() OVER (...) to page data from tables... I was convinced that the exp…
9 replies
Hi All, First off im a TSQL Novice...so help is needed and much appreciated within several tables i…
19 replies
I'm trying to alter a column after I disabled the constraints, but it still says the constraint is …
2 replies
hi team, Could you plesae explian with any example how to use/declare local and globle variables in…
2 replies
Viewing 15 topics - 5,026 through 5,040 (of 10,640 total)
You must be logged in to create new topics.