Topics
Started by
Posts
Last post
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
Hi, I would like to write a query for following structure table... Id Text …
1 replies
Stumbled across this at work, just had to share. SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO…
23 replies
I would like to use SQLCMD to run a large script stored locally on command. To do this, I would li…
4 replies
I need to convert Oracle SQL SPs and functions to SQL 2005. Table and columns names do match. Is th…
1 replies
Viewing 15 topics - 9,196 through 9,210 (of 12,230 total)
You must be logged in to create new topics.