Dear friends, I need your help and expertise. I'm trying to import several log files into a table b…
2 weeks, 3 days ago
Is there a scenario whereby you would create a stored procedure with the option
Set Xact_abort ON
1 month, 2 weeks ago
Following function works if the parameter to harcoded as shown below.
But i would like to replace t…
3 months ago
Why does SELECT CONVERT(varchar(4),263000) or SELECT CAST( 263000 AS varchar(4)) return * ?
3 months, 1 week ago
I have been struggling with this T-SQL for much too long today. I am using the S…
8 months, 1 week ago
Hi,I am struggling to write a procedure which looks up a value in a lookup table.See desired result…
9 months, 1 week ago
Hi i have column with data type as Varchar.The coloumns contains the numbers with decimal point in …
I need to create a stored procedure that queries a SQL database, calculates an XIRR (consi…
I've been researching for past two days and hitting my head against wall, but I can't figure this o…
10 months, 4 weeks ago
Did anyone ever have to create a function/stored procedure that would take a date as an in…
1 year, 1 month ago
So we're looking at implementing FTS for a few term type lookup things in one of ours apps.
I like to get the number of consecutive years a customer have placed ordres starting from curren…
1 year, 3 months ago
By: cg 23106
I'm trying to determine if there's a way to get a server's alias programmatically?
By: Steve Jones - SSC Editor
I'm trying to get the server name programmatically.
Even after I do this:
I'm running into the following message, "String or binary data would be truncated. [SQLSTATE 22001]…
1 year, 4 months ago
Viewing 15 topics - 1 through 15 (of 10,644 total)
You must be logged in to create new topics.