SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• weekly data load into SQL

  hi,I have experience with SQL queries, but never got exposure about loading data. We get weekly ext…

  nkpriya_2002

  1 replies

  9 years, 7 months ago

  By: MMartin1

• Help creating stored procedure with cursor loop

  Hi, I'm having trouble with my SQL class assignment and would really appreciate some advice. I app…

  hyper50

  6 replies

  9 years, 9 months ago

  By: Kristen-173977

• outputting a message based on query results

  I am trying to get this to work without having to write a cursor or something like that. I think i…

  christine 23290

  1 replies

  9 years, 9 months ago

  By: Eirikur Eiriksson

• trigger ddl export to file/grid

  Hi, Does anyone know how can i export/query all the triggers' DDLs of certain database to grid/fil…

  osseth

  4 replies

  9 years, 9 months ago

  By: PaulFenton

• Invalid character for specified code page column 1

  Hi SQL Central. I am working on a BULK INSERT Statement using a FORMATFILE and I am getting this er…

  Scubba-Steve

  1 replies

  9 years, 11 months ago

  By: Scubba-Steve

• SSIS Multiple FlatFile imports with Multiple Delimiters and XML in a txt document

  Hello everyone . So I have decided to use SSIS in Management studio 2012 to achieve the task of imp…

  Scubba-Steve

  2 replies

  10 years ago

  By: Scubba-Steve

• Need Help for SSIS Config File

  Hi All, Please help me, I have a questions regarding SSIS Config file. Last month I have bought S…

  stephanigracie

  1 replies

  10 years, 1 month ago

  By: Eirikur Eiriksson

• Current Date order Query

  Hi Guys, I am kind of struggling to get the result for current date orders but I can get the query …

  yusufm 48726

  7 replies

  10 years, 1 month ago

  By: Sean Lange

• Query to do exception report based on 2 values in a specified field

  Hi, I need to run an exception report on the following data where [Field4] has a value of 'COLLECTI…

  -OLDdogNEWtricks-

  5 replies

  10 years, 2 months ago

  By: Y.B.

• SQL Query

  Hi Guys, I am trying to create a report from view and I am stuck on dates and Value. I have got sce…

  yusufm 48726

  6 replies

  10 years, 2 months ago

  By: yusufm 48726

• Get Month Name

  Hi all Is there any best way to get month name in SQL SERVER 2005. I know that we can do this using…

  Shakti Singh Dulawat

  29 replies

  10 years, 4 months ago

  By: MMartin1

• CASE statement using TEMP table and WHERE statement?

  Good Evening stumped again, trying to convert local currency to USD through a temp table I created …

  rickyschroder

  1 replies

  10 years, 4 months ago

  By: rickyschroder

• Max value subquery?

  Good afternoon, struggling to come up with a way to select all the values listed when the carat_id …

  rickyschroder

  3 replies

  10 years, 5 months ago

  By: Jeff Moden

• Check if database exist

  How can I check if a database exist before using it. I am running several scripts in one file that …

  wanox

  1 replies

  10 years, 5 months ago

  By: Lowell

• Linked Server Error

  After configuring a SQL Server linked server using Oracle Oledb provider, I am unable to run querie…

  EMtwo

  1 replies

  10 years, 6 months ago

  By: EMtwo