Search results

IM trying to have a where clause look for todays date and pull all the data from todays and all the data within the next 6 days. i dont want to use any parameters just automatically do it. Im not sure how i would do this, any help would be great.

SELECT * FROM [DSIPAR].[dbo].[bk_v_nif_OnHandInventory_BaseWithTests] where Receiptdate = '8-28-2010' and item = '07603' order by CLng(Split(LotNumber, "-")(1)) When i run that, i get an error saying: Msg 195, Level 15, State 10, Line 7 'Split' is not a recognized built-in function name.

I know every field has a "-" in it, i also know the whole field isnt numeric.

i have a simple query i have attached below. one of my fields is called LOTNUMBER which looks like this for example 240-32(240 is the julian date, and 32 is the bag number. what my issue is when sort them in asc order they end up looking like this: 240-1 240-10 240-11 240-12 ect and i want it...

I have a qurey in a data set in reporting services. What im trying to do is use the shipdateyear field as a parameter but i keep getting an error when im running it. I think its because how im getting the name shipdate year its coming from a field where im formatting the data to just show...

Ok im getting somewhere now. but its still not what i want my following query returns this in the shiptime field: Jan 1 1900 3:00:00:000PM everything is correct but how can i take off the Jan 1 1900 part? I dont need that i just need time...Thanks. select bol.loadnumber...

Yes thats the conversion i want. I dont see anything on that convert link about military time...

This is my sql statement, and im now getting my shiptime field in a time format but i still want to get it to non military time, how can i do that? select bol.loadnumber, bol.testname,bol.testscore,bol.ldhshipdate, substring(right('000000' + ltrim(cast(bol.shiptime as varchar(6))),6),1...

anyone help me on this? Im not sure where to insert my field so that it converts my specific field to the format i want...

I have tried that but im not sure how to use that within my query? the field i wanna convert is called shipdate. any ideas?

I have a sql table that has a date field but the dates are in a format like this: 90000 = 9:00:00am or 190000 = 19:00:00pm what i want to know is how can i convert those values to normal time values and if they are military time convert those to 12 hr time formats. my ending goal would be...

Yep i have tried both of them.

Hi I have a terminal server with a remote user who has HP laserjet M2727 pcl6 driver. We just got a new server and no one can find the disk to re-install this driver. I have downloaded sever off the internet and they dont work. I was wondering if anyone had that kind of printer and could...

Hi i have a terminal server that runs Windows Server 2003 R2 standard it is a brand new machine put in a few months ago. When my users connect they run a custom application for our company as well as IE 8 and excel 2007 We have been getting alot of freeze up, lock ups by the users and in the...

Hi i am trying to block websites locally via the host file. i have done lots of searches for this but have had no luck getting it to work. any help would be great here is my host file below. # Copyright (c) 1993-1999 Microsoft Corp. # # This is a sample HOSTS file used by Microsoft TCP/IP for...

Hello Before i took over at my current job, someone created in access 2003 a interactive webpage. all the page displays is by location of our clinics and who has certfication dates due for various things therapist need to be re-certified. Most of the users access the page via a sharepoint...

none of the excel files are zipped, its just a file but when the user goes to open it it asked to unzip even though its not a zip file makes him save the file and then he can open it fine.

anyone have any thoughts on this?

I have a user who has office 2003. He gets emailed office 2007 documents frequently, he does have the conversion tool installed, however, from his email when he clicks to open the file it makes him unzip and save the file before he can open them. i have looked and looked and cannot find out...

Hello, We have been having alot of issues at one of our locations. I discovered that we have two computers with the same name? what kind of issues would this create?