Topics
Started by
Posts
Last post
Is there a scenario whereby you would create a stored procedure with the option Set Xact_abort ON A…
4 replies
Following function works if the parameter to harcoded as shown below. But i would like to replace t…
2 replies
Why does SELECT CONVERT(varchar(4),263000) or SELECT CAST( 263000 AS varchar(4)) return * ? You wou…
6 replies
Hi everyone, I have been struggling with this T-SQL for much too long today. I am using the S…
6 replies
Hi,I am struggling to write a procedure which looks up a value in a lookup table.See desired result…
14 replies
By: JJR333
Hi i have column with data type as Varchar.The coloumns contains the numbers with decimal point in …
4 replies
Hi Gang, I need to create a stored procedure that queries a SQL database, calculates an XIRR (consi…
4 replies
I've been researching for past two days and hitting my head against wall, but I can't figure this o…
11 replies
Hi guys, Did anyone ever have to create a function/stored procedure that would take a date as an in…
11 replies
So we're looking at implementing FTS for a few term type lookup things in one of ours apps. Of cour…
14 replies
Hi I like to get the number of consecutive years a customer have placed ordres starting from curren…
2 replies
Hello, I'm trying to determine if there's a way to get a server's alias programmatically? Scenario:…
3 replies
Hello, I'm trying to get the server name programmatically. Even after I do this: exec dbo.sp_dropse…
1 replies
I'm running into the following message, "String or binary data would be truncated. [SQLSTATE 22001]…
12 replies
hi there i have 5 database with same table schema in my branches i want to have one data base in my…
7 replies
Viewing 15 topics - 16 through 30 (of 10,635 total)
You must be logged in to create new topics.