I thought that was too simple...

I might try building this dynamically then, as if it were a program in C/VB/Java....

Example of what I mean:

declare @one varchar(255)

declare @two varchar(255)

select @one...

Not completely clear from your example if this helps, but for what it's worth:

*********************

declare @one int

declare @two int

declare @three int

SELECT @one = 1 , @two = @one + @one,...

I used Google and found these links:

http://jan.ucc.nau.edu/~cvm/latlongdist.html (code is in Perl)

http://www.freevbcode.com/ShowCode.Asp?ID=5532 (code is in VB)

http://www.hotscripts.com/Detailed/20791.html (various code, including C/C++)

I might take a crack at...

You're probably looking to use ISNULL(). Something like:

SELECT ISNULL(t1.col1,t2.col2)

FROM table1 t1, table2 t2

WHERE ....

The t2.col2 could also be a seperate SELECT statement if the tables don't join in the query,...

SELECT ...

FROM ...

WHERE myCol >= DATEADD(dd, -7 + -DATEPART(dw,getdate()), CONVERT(char(8),getdate(),112))

AND myCol < DATEADD(dd, 1 + -DATEPART(dw,getdate()), CONVERT(char(8),getdate(),112))

This should capture the previous weeks end points dynamically, and also allows you to...

Just found this via the next post ...code is ASP, so you should be able to use alot of it as is.

http://www.nigelrivett.net/DBAccess.inc.html

Thanks to Nigel for sharing the scripts.

Jeff

...

Look at:

xp_sendmail

in the online books - it should explain all the parameter values well enough for your emails. Simply create a VB connection and...

Going out on a limb here to contradict some people who are obviously more experienced than I...where's that damn ripcord!

The posters in this thread seem to assume a few things:

1)...

Try using more than one connection object. The same connection cannot start the next query with pending results in MS SQL Server - we run into this alot with various...

Everything in your code looks fine - did it fail for you?

When inserting with an identity column, just leave that column out of the insert.

Ex:

create table tbl_users

(

idcol int IDENTITY (1,...

Check out lowphat's post from a couple of days ago:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17548&FORUM_ID=8&CAT_ID=1&Topic_Title=How+can+I+make+pivot+table+from+these+data%3F&Forum_Title=T%2DSQL

If the other database is linked, just refer to the table by its full name (myServer.myDatabase..myTable). If they're on the same machine, I think you can leave off the servername...

OK, here's the code:

***************************************

if exists (select * from sysobjects where id = object_id(N'[dbo].[listResults]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[listResults]

GO

create procedure listResults

as

begin

declare @onePass int

declare @seq int, @kuks int , @countTdkuks...

Zaza,

Use a CASE statement:

(CASE A.PDepartment WHEN '' THEN B.PDepartment ELSE A.PDepartment END ) CaseCol

Be sure to give the case column an Alias or the View won't...

hi synakamr,

I came up with the same query as David, which made me realize your problem. David's query produces:

SEQ KukS ...