Topics
Started by
Posts
Last post
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
I have a datetime (your standard yyyy-mm-dd hh:mm:ss) column and a varchar column that holds an app…
16 replies
As topic. << I am a self confessed SQL total noob but trying hard I am am helping a couple of…
2 replies
Hi, need some help to write the query as i am not sure how to achieve this. I am having a table for…
14 replies
Today we had a problem with a stored procedure in production, here is the code within the SP: SELEC…
8 replies
Hello, I have a problem with a stored procedure returning a result set from a query containing mult…
9 replies
Here is my scenario along with the SQL commands, USE dbo_test --Create a sample table GO CREATE TAB…
9 replies
Hi Everyone,, i have a table like facilityid facilityname PlannedThisMonth ActualThisMo…
1 replies
How to substring or replace 0x from a binany value 0xF60F9125DBA7E94012F55E2177C95C0E906862B1 in SQ…
3 replies
i want to find the increase / decrease amount group by sector and month. --input table declare @t t…
6 replies
Viewing 15 topics - 5,041 through 5,055 (of 10,647 total)
You must be logged in to create new topics.