Topics
Started by
Posts
Last post
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
How can I use datepart to select records between a certain date range without having to hardcode th…
4 replies
I have data stored in a table as follows: ProjectNOIYear 24-21.672007 24-1.632006 2441.4920…
4 replies
I am trying to convert code over to use the native XML data type instead of using sp_xml_prepare…
1 replies
After moving the nonclustered indexes to seperate disk array on secondary filegroup the CPU usage i…
4 replies
Viewing 15 topics - 8,461 through 8,475 (of 12,230 total)
You must be logged in to create new topics.