Topics
Started by
Posts
Last post
Hi, I'll say up front I am far from a T-SQL expert but I like to think I am quite intuitive 😀 Anyho…
2 replies
In t-sql 2012, I have the following sql that I would like the following to occur: 1. commit or roll…
1 replies
Okay, this is confusing. When I do the following, I get a result of 1. SELECT IDENT_SEED('tablenam…
3 replies
In a special request run, I need to update locker and lock tables in a sql server 2012 database, I…
7 replies
Hi all I need to check to do a check on a built in server role and check it's permissions are in pl…
13 replies
Hi All, I have an sql as follows: select count(*) from Split1 st1 full outer join split2 st2 on st1…
1 replies
Hi I'm sure there's a really simple answer to this but I'm really struggling, similar questions hav…
4 replies
I need to create a query where patients have delivered and may have returned within a certain numbe…
1 replies
Following the horrendous performance of Scalar UDFs demonstrated in this thread http://www.sqlserve…
32 replies
Hi folks, I have used cursors in a similar way 100 times (but not in a couple years). I am selectin…
10 replies
Can someone look over this script and tell me why I'm getting an "Incorrect syntax near 'Go'" error…
9 replies
Hi, I have a scenario where I need to develop a stored proc to identify invalid input provided. Fol…
11 replies
Hello I've started getting an issue with this command It's trying to access a specific directory an…
1 replies
I have the following that defines one column in a view: IIf(IsNumeric(Contracts.PurchaseOrder)=1,C…
31 replies
This is odd. It's the first time I am using an aggregate with the OVER clause. Running the script …
2 replies
Viewing 15 topics - 2,731 through 2,745 (of 4,984 total)
You must be logged in to create new topics.