Search results for query: *

Is there a better way to add a table name suffix that will adjust to add the correct month and day when the month does not correspond to the reporting period? The below code works when the last day of the month is also the run day and month of this report. I need to be able to add the correct...

Is there a source out there (books etc) that will enable a beginner to learn and understand Cognos i.e cube building etc?

Can someone point me in the direction on getting access to some basic material on writing syntax for Dynamic SQLs? I need to understand the basics on using and placing for example the '+', quotes etc. Thanks

I keep getting the syntax error:Incorrect syntax near the keyword 'From'. I assume it is referring to the last line where a FROM exist. Any help is appreciated Declare @InPutDate as VarChar(255) SET @InPutDate = '_'+ CAST(Datepart(month,GetDate()) as VarChar(2)) + '_W' +...

I keep getting the error:Server: Msg 156, Level 15, State 1, Line 26 Incorrect syntax near the keyword 'From'. When I try to run the following code. Any help in solving this is greatly appreciated. I assume the error is referring to the last line where the FROM exist. Declare @InPutDate as...

I get the same error but I am trying to use 404,000 rows of data with 512K of ram and using Access 2000. Did you ever findout why you are getting the error 'low on memory or out of memory'?

I am trying to create a pivot table using Access 2000 and a table with 424,000 rows but when I get to the layout and it loads the data from the table it loads ot about 392,000 rows and I get the error 'Low on Memory' My question, Is there a max number of rows an Access database Pivot table will...

Is it possible to reference temporary tables created by using a second SQL Query Analyzer session? My problem is that I have two SQL Query Analyzer windows running, the first one creating temporary table and the second runs SQL that try to reference those temp tables once created.

I am needing to schedule a series of SQL to run at a speicfic time and day. Are there any codes out there that would accomplish this task?

I am trying to import an excel file with zip+4 data that includes leading zeros. When I import using DTS the leading zeros are dropped. Is there a way to do this and keep the leading zeros?