Topics
Started by
Posts
Last post
Hi all. I have a requirement in which customer fills in a form. The provided form fields are search…
2 replies
Im getting an error that says "Incorrect syntax near the keywork VIEW." CREATE PROCEDURE sp AS…
2 replies
How does one return results so that "Top 1" works within the "Group By" results? I don't…
3 replies
Greetings, I have a "main" stored procedure that executes other stored procedures and it loo…
2 replies
Hello!!! It might be easy (for u) but i'm stuck on this, i have an sproc where i calculate tot…
4 replies
Any suggestions for the following would be appreciated. I have tried a few different triggers…
3 replies
Hello!!! It might be easy (for u) but i'm stuck on this, i have an sproc where i calculate tot…
3 replies
I'm not sure if this question belongs here as it's more philosophical than 'how to' but here goes..…
18 replies
Hi there, I'm trying to run the following script on a linked server: SET XACT_ABORT on INSERT INTO …
2 replies
I have a sql query that uses a % wildcard like so: SELECT PIN, SCAN...etc... FROM PARCEL WHERE…
3 replies
When calling OBJECTPROPERTY with IsAnsilNullsOn and IsQuotedIdentOn against version 7 tables in a s…
1 replies
Hi all I am doing a Db porting project, the code in plsql has to be converted tsql.I have a t…
4 replies
Hi, I want to use CASE statement in FROM clause, for example DECLARE @I INT SET @I = 1 SELECT * FRO…
6 replies
Hi, I have a table structure like this TableName: Common Columns PartnerId: int NativeId: int First…
3 replies
I have a table : MyTable (id, name) I have a procedure fgirtest which is : CREATE PROCEDURE fg…
8 replies
Viewing 15 topics - 13,306 through 13,320 (of 17,082 total)
You must be logged in to create new topics.