Topics
Started by
Posts
Last post
Hi I hope this is an easy question to answer. 🙂 I'm joining a large table to a small table and&n…
12 replies
Dear friends, I need your help and expertise. I'm trying to import several log files into a table b…
4 replies
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
By: NedaYar
Hi,I am struggling to write a procedure which looks up a value in a lookup table.See desired result…
14 replies
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
Viewing 15 topics - 1 through 15 (of 10,644 total)
You must be logged in to create new topics.