Search results for query: *

I am using SQl 2005. I am trying to accomplish a simple view sql select using WHERE Clause conditional based on End of Month date This is my View sql Alter view view_name as select * from table Where Active_client = 'Y' And sales = 1 AND (if day(getdate()) = 1 -- Beginning...

I am trying to execute a command to transfer data file within SQL job agent using FTP I have created a dos batch file called ftp2site.scr: --ftp2site.scr: REM -- BEGIN BATCH File @echo off open 216.22.1.333 mylogin mypass cd /user/download put "CustDataFile.xls" bye REM -- End OF FIle FTP works...

Ihave 2 files that are schedule to execute arouund mid day. I need to find out how can I scheduleto FTP these 2 files within Sql jobs. I have the following: Set @FTP_Server = 'ftp://123.456.789.155' Set @FTP_User = 'mylogin' Set @FTP_PWD = 'mypass' Set @FTP_Path = '/user/invoice_import/' Set...

Using Crystal Report 9. I am using Join(parameter,",") to display user selection. My question is it possible to display the parameter description as well. Thnak you

Using: SQL 2005 on the server login: sa (administrator) I am trying to schedule an export to excel. It works fine when executed manually but when I tried to schedule a job it Fails. I know that the problem is between our server SQl (which is 64 Bits) and Excel using 32 bits. How can I resolve...

Problem Or BUG in SSIS package scheduling a JOB using SQL 2005: I have been trying to create SSIS package in SQL 2005 but it seems extremely difficult to deploy a new job schedule. I tried all security features, read about every forum still not successfull. even Microsoft admit that scheduling...

This should be quite simple. I have spent 4 hours trying to figure it out. I am trying to export sql view to an excel file and it is failing because of the login sa. These are the steps to export. Using Sql Server 2005 1 - Used Import Export wizard in sql 2 - logged in as sa + pasword 3 - Saved...

SSIS: I am using SSIS package to get sql to an excel file output. The operation failed due to the character string between sql and excel. However I was able to use the import export utility to execute sql to flat file which works beautiful. So I am trying to get Ascii to excel. SSIS: SQl -->...

I am using CR9 I was wondering and it is very helpfull to have a function to print window username in the report. ******************************************* Is there a function in CR9 to print Window user name login ************************** Please advice Thnk you D

I am using sql 2000: I need to select some fields from an already defined complex stored procedure. and then calculate some var based on returns fields from the stored procedure. i have : p1=pass parameter1... stproc(p1,p2,p3) which returns table with field1,field2,field3 I need to create a...

I am kind of new to sql. I need to write a function or a view table that I will use in a report which returns a string based on sql select I need to pass (client_id, prim_var, sec_var) sec_var = can be null and return a string with all eligible with ',' delimiter ie: pass 1,A,BC ===> return...

I am having a problem printing total in group header. I am using CR 9 and having a problem suprressing group header based on conditional count. Group header: Client, Client Name.... Detail: will print only if condition is met. (using suppress) all counter/formula are are working ok, with the...