Topics
Started by
Posts
Last post
Hello, I'm stuck at my sqlquery. What I want is to: Group by ID and Location. Sum Quantity and Cost…
6 replies
How do I query this field? Is this possible? Thank you for your help! I removed the < for displa…
12 replies
Hi, Would anyone provide the useful query for the below requirement? i want you to create a functio…
3 replies
Hello all, How can I cast the 'N/A' in order to meet the field type requirements? CASE WHEN DA…
2 replies
Hi guys, I got a strange behaviour executing a stored procedure. The SP works fine when executed fr…
9 replies
hi, i m new to sql. can any one brief the function of the below query and how it works select * fro…
2 replies
I HAVE A QUERY THIS WAY .. select convert(varchar(12),datepart(m,date)) + '/' + convert(varchar(4),…
11 replies
runiing the code below from database named Rabbit: INSERT INTO ptEncounterEncounterDetailTemp (Enc…
10 replies
What wud be the impact of changing and INT to Varchar in production databases, what will be the bes…
2 replies
Well, I have never seen anything like this one before! I have a stored procedure that accepts a nu…
11 replies
Im stumped and I KNOW this is a simple query. Lets say I have this . select column list from tablen…
9 replies
Hi, We have an Access front end app that connects to a SQL database. At present it is running on A…
7 replies
We have one table with a column named DiagPtr where the data can contain a string in the format '1,…
4 replies
Hi Forum, I need to create a Stored Procedure which will receive the name of a table as parameter a…
2 replies
I'm setting up to use Row_number() for paging - It's ideal for this. But, I am finding that there i…
5 replies
Viewing 15 topics - 8,461 through 8,475 (of 12,234 total)
You must be logged in to create new topics.