Topics
Started by
Posts
Last post
create table #temp (id int, data varchar(80)) insert into #temp (id, data) select 1, 'a,b,c' union …
8 replies
We are changing our drives this weekend.. and will have a different drive letter to write out job l…
2 replies
I have one table dbo.t1 with data like this: Col1Col2Col3 XYZ12RXM XYZ13XUV XYZ14RXM MOP22…
9 replies
I am trying to create a schedule/calendar. Table A shows my slots. Table B shows start/end times fo…
3 replies
Hi All, how to identify different fields with in a group of records? Example: create table #test (…
1 replies
Below SQL gives the results of 2 columns and I need the DepartmentandDate column to be ORDER BY on …
6 replies
Hi I have a requirement to calculate the total outage time, based on logged fault tickets, of netwo…
3 replies
Help needed for the below task as i am not able to get a hint how to resolve the below task create …
6 replies
Hi Guys, I am using a PIVOT function to obtain the Invoice Values, but they appear in different cur…
2 replies
HI All, I have an issue while display the result in the required order. please help me to get the r…
5 replies
Hi, I am trying to build a simple time table and pre-populate the rows for lets say 1 year. Basical…
5 replies
Hello, i am trying to convert a string like this 'le dd/mm/yyyy' into a datetime. I have removed th…
3 replies
My query pulls data from two separate databases, and it runs extremely slow. The queries run well w…
9 replies
Hi This my stored procedure ALTER PROCEDURE [dbo].[PageWise] @PageIndex INT = 1 ,@Page…
8 replies
select Queue.ScheduledTaskQueueId QueueId, Queue.QueueMaximumLength, Queue.IsLargeQueue…
19 replies
Viewing 15 topics - 2,011 through 2,025 (of 10,635 total)
You must be logged in to create new topics.