Topics
Started by
Posts
Last post
Hello comunity I build a UDF scalar function like this: CREATE FUNCTION VerificaAcessoPerfil (…
21 replies
how to round the nearest value after round of decimal and return integer. thanks. declare @data d…
3 replies
Hi, I need to generate unique string Id from the range AAAAA to PZZZZ. This id will be unique for e…
3 replies
First, a little background info. I am using SQL Server 2008 as a back end for a Microsoft Access f…
8 replies
Hello- I've been struggling with this for some time. we have to group data based on Patients admiss…
1 replies
Not sure if this is ever going to be possible, but I'm trying to do a dynamic join on EXECUTE, but…
15 replies
I have a table imported from a legacy Oracle database that stores values vertically in name/value p…
2 replies
Hello, My question is about how a cte works. Looking at a stored procedure written by someone else…
12 replies
In the code below I have induced an error in my called sproc. I want the record version to not com…
5 replies
I would like to query for two columns- either of the two returns null but not both. For example: If…
7 replies
Quick one for you all. I dont have access to test this or I would but I know you all are quick to …
5 replies
Problem: I have a table with 370 million rows and 50+ columns. I need to change the data type of a…
9 replies
Hi All, Need expertise in making my view run fast. Please find the below Query(view) which i am ref…
7 replies
Hi, Can we use case in pivot like below? I am getting an error. I want to do Pivot on condition bas…
2 replies
Hi, I want to get "all combinations of the same count" for provided list of numbers. As an example,…
7 replies
Viewing 15 topics - 1,126 through 1,140 (of 10,647 total)
You must be logged in to create new topics.