Topics
Started by
Posts
Last post
we know that when using RaiseError function, the function supports providing parameters to subsitit…
2 replies
[font="Arial"]I have five columns in my table: Statement_num Fees_Due Initials Fees_Billed Credit…
8 replies
Hi SQL Experts, I have a table with the below structure: Pri_ID RefID ParentID 1 …
6 replies
I am creating a stored procedure. Following is the codE: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON…
1 replies
Hi members, I am getting the following error: Cannot resolve the collation conflict between "Latin1…
4 replies
How can I calcuate the first date and last date of the year when I pass in just the year. Something…
7 replies
I am trying to use the simple BULK INSERT command to load the data from a flat file to sql server t…
12 replies
I have 2 queries below. Both before the exame same as far as performance and result. Is there a b…
3 replies
Insert into tblemp Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=\\stated…
11 replies
Dear all, I have a problem with my CASE Statement. The purpose of the below query is to filter the …
8 replies
Hi, I have been working on optimising 1 of our search SP's over the last few days and although I ha…
5 replies
Dear All, I was wondering what the syntax what be to append an IF statement in the where clause fo…
12 replies
Given a 20 million row table of not overly dyanmic data, which is "better" given that 'stringfield …
4 replies
We have a bigint number (64 bits), and I need to retrive a bit value ( 1 or 0) for a given bit numb…
1 replies
Hello I am using the following query: ELECT DISTINCT T_OrderHeader.OrderDate, T_OrderHeader.Orde…
5 replies
Viewing 15 topics - 9,196 through 9,210 (of 12,234 total)
You must be logged in to create new topics.